Schema upload (.df) through cmd line

[casorohi]

Hi everyone need a help regarding schema upload (.df) through cmd line and want to run the job/process in background.
Actually a new index needs to be created on table size 60.6 GB, so when I update the schema through datadictèADIM è load df . it start successfully but after some the connection/session disconnect due to some firewall setting(ideal session timeout) with following message:

Read from remote host 10.128.80.88: Connection reset by peer
Connection to 10.128.80.88 closed.

As result the schema upload fails, so I want know is there any way upload schema through cmd line and run the process in background by ending the line with”&” or any other way to tackle this issue.

OS: Linux 64bit with OE102B
Changing the firewall rule is beyond reach.
Thanks
caso

 

[Stefan]

Never tried this, but define the index in your df file as inactive - this should result in a very quick load. You can then activate the index afterwards.

 

[TomBascom]

Stefan is right.

But it is also not at all hard to set your terminal to send a keepalive packet every so often

Lastly, make sure to upgrade to 10.2B service pack 6. The index rebuild utility has had a major overhaul and it is a lot faster in sp06.

 

[durkadurka]

Maybe try this is your ~/.ssh/config ??????

Host 10.128.80.88
  ServerAliveInterval 45
  ServerAliveCountMax 6

 

[casorohi]

How to tackle these two scenario/Index:


1)
ADD INDEX "idx_brochure_date " ON "brochure"
AREA "bpr_idx"
INDEX-FIELD "brochure_id" ASCENDING
INDEX-FIELD "no_of_days" ASCENDING
INDEX-FIELD "price_start" ASCENDING
INDEX-FIELD "dcs_excep_type" ASCENDING

UPDATE PRIMARY INDEX "idx_brochure_date " ON "brochure"

DROP INDEX "idx_BrochurePeriod" ON "brochure"


2)
ADD INDEX "idxsuppprice" ON "supplier_product"
AREA "idx_area"
DESCRIPTION "idxsuppprice"
INDEX-FIELD "vendor_id" ASCENDING
INDEX-FIELD "supplier_id" ASCENDING
INDEX-FIELD "product_id" ASCENDING
INDEX-FIELD "pricing_group_id" ASCENDING
INDEX-FIELD "record_id" ASCENDING
INDEX-FIELD "valid_from" ASCENDING
INDEX-FIELD "valid_to" ASCENDING

UPDATE PRIMARY INDEX "idxsuppprice" ON "supplier_product"

DROP INDEX "idxvsppgseason" ON "supplier_product"


thanks

Caso