Search found 8 matches

by pradeepkumar
Mon Dec 08, 2008 11:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reg Loading using ODBC
Replies: 2
Views: 1784

Reg Loading using ODBC

While loading large amount of data using ODBC it is slow, is there any other alternative way to load data very fastly if there is any long Varchar field, because if we increase the transactuion size for the table having long varchar we are getting error while loading. the error is: Abnormal terminat...
by pradeepkumar
Mon Dec 08, 2008 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reg loading of data
Replies: 1
Views: 1788

Reg loading of data

In order to load large amount of data we had used SYBASE BCP load, but we could't able to load because of the following error:

"user api layer: external error: The connection has been marked dead."

Is there any way to rectify this problem. Please hep me out in solving this problem

by pradeepkumar
Sat Jun 21, 2008 1:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clean up resources in Director
Replies: 8
Views: 4588

Re: Clean up resources in Director

Hi i am posting collection....... Log into DS Administrator Enter LIST DS_JOBS <job name>. The job name is case sensitive. Write down the job number. Run LIST.READU EVERY. Look under the Active Record lock at last column Item-ID. Look for locks on the job name or anything associate with the job num...
by pradeepkumar
Fri Jun 20, 2008 9:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clean up resources in Director
Replies: 8
Views: 4588

So... the 'Show All' buttons don't show you any processes? :? You have to be logged in as the "Administrator" to work with other people's processes. ... The "Show All" doesn't show any of the processes. Previously it has shown all the processes running and their Process ID. Curr...
by pradeepkumar
Fri Jun 20, 2008 9:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clean up resources in Director
Replies: 8
Views: 4588

Clean up resources in Director

Clean up resources in Director not showing any of the process ID and Processes. I am not able to unlock the jobs being accessed by other users. What needs to be done to get back all the process ID.





Thanks in advance

Pradeep.
by pradeepkumar
Wed May 21, 2008 9:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge
Replies: 3
Views: 2176

They may not have the same names on the input links. ... It will have different names, thats fine. Consider this example we have two files with empno as key and we are joining it using that key. In output column we need to give both the keys with different name, but what is the use of other empno w...
by pradeepkumar
Mon May 19, 2008 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge
Replies: 3
Views: 2176

Merge

While merging two files with key fields, What is the need to give both the key fields in the output of merge stage? Any reason behind that?
by pradeepkumar
Sun May 18, 2008 11:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort stage
Replies: 2
Views: 1833

Sort stage

In sort stage, While specifiying sorting specifications, what is the use of collating sequence map file? Please explain with an example....