DSXchange

Thanks for you valuable information.

Satheesh.R

Hi All, Regularly we are building the hash file by using the job with the following command:CREATE.FILE HashFile DYNAMIC MINIMUM.MODULUS 150000 GROUP.SIZE 2 SEQ.NUM SPLIT.LOAD 80 MERGE.LOAD 50 LARGE.RECORD 4096. Today the job was aborted and saying that "WriteHash() - Write failed for record id...

Hi All,

What are the things need to be take care of such PX hangs?we missed the SLA's after long time due to the PX job hangs....So kindly suggest me the things to be taken care by the job running in Production.







Thanks&regards,
Satheesh

Hi Kumar, The records was not fully populated.The job hangs for almost 4 hours...normally it take 30 minutes..while rerunning the same job i can able to execute the job in 30 minutes..It's really painful to identify such cause....Kindly give me your suggestions for such odd things. Thanks&Regard...

Hi All, I have a strange on my yesterday cycle.The PX job hungs for more than 4 hours.Normally it takes 30 minutes to finish.The same job runs past one year, we never faced this kind of problem..The job is in running status only for more than 4 hours.we are using TNG Unicenter to schedule the job by...

Hi All, How to create read only jobs in Datastage.As of my knowledge there is an option for releasing the jobs in manager Tools option. In my production box with exclamation mark 'JobName' is Read Only. Any changes that you make cannot be saved. . Kindly share your ideas for creating such read only ...

Hi Gateleys,

Even we are also following the Daylight Savings Time(DLST)...We scheduled our jobs through TNG Scheduler...At 2 Am we set the server time as 1 AM...so the normal jobs completed 1 hour later than the previous day...



Thanks,
Satheesh

Hai, One small doubt.I have a sequential file which contains Date and terminal id : 20060825,00001234 20060409,00002345 like this I my unix inbox folder contains the following files: ras.dltx.postrn.20060725.070547.00001234 ras.dltx.postrn.20060409.070547.00002345 ras.dltx.postrn.20060719.070547.000...

Hai, My file is in /cust/ris/dev/data/rwinbound/pos2/unfid_errors(Unix) verify that POS data has been processed for the file date and terminal id. File Name : ras.dltx.postrn. 20060719 .070547. 00002973 Date : 20060719 terminal id: 00002973--How to get the date and terminal id for each filename from...

Hai, while we run a set of sequence jobs for FTPing a CSV file from LAN to Unix box it shows the following error: DSJobController=JobSeqFTPRewApsdCSVFile JobSeqFTPRewApsdCSVFile..JobControl (DSRunJob): Waiting for job FTP7InsightCSVFile.FTPFIN to start JobSeqFTPRewApsdCSVFile..JobControl (DSWaitForJ...

Hai,


Just write a shell sciprt.To add your list like this

#PAGER 3546478@pagemart.net

#satheesh@mail.com and initiate it to shell.


Regards,
Satheesh.Rajan

Hai Guy's, Here is the Query: select /*+ full(s) parallel(s,#PAR_DEG#) full(n) parallel(n,#PAR_DEG#) full(l) parallel(l,#PAR_DEG#) ordered */ s.PERIOD_ID, s.DIVISION_CODE, nvl(n.ITEM_GROUP_CODE,0), s.NTNL_ITEM_GROUP_CODE, nvl(n.PRICE_ZONE_CODE,0), n.PRICE_ZONE_TYPE_CODE, round(nvl(AVG(s.AVERAGE_FORE...

Hai Guys,

The job is completed while reducing "The parallel degree for the sql statement from 8 to 1".

why parallel degree 8 works sometimes and not others?






Regards,
Satheesh.R

Hai, I got the following error.Kindly give me your valuable suggestions. LoadStgSaleForecastSGPzWeek..SrcStgSaleForecastNigWeekOra: ORA-12801: error signaled in parallel query server P007 ORA-01652: unable to extend temp segment by 1024 in tablespace TEMP Attempting to Cleanup after ABORT raised in ...

Hai All,


How to search a particular job in the repository. Because i have more than 180 jobs.If i want to pick a job we have to go through all the repository folders.Is there any option available to search a job in DS Designer or DS Manager?

Regards,
Satheesh.rajan