Search found 10 matches

by amarnadh0203
Tue Aug 05, 2008 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage error
Replies: 9
Views: 3014

Thank you very Much... :)
by amarnadh0203
Tue Aug 05, 2008 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage error
Replies: 9
Views: 3014

Project:IS_Risk_Control (tedshdu2:31539)
Job name:CopyOfP001_SP_Job
Event #:17
Timestamp:8/5/2008 7:58:03 AM
Event type:Fatal
User:n431c7
Message:
ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

Sorry for being over confident... here it is what i have got from event log.
by amarnadh0203
Tue Aug 05, 2008 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage error
Replies: 9
Views: 3014

ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

thats all i can see in the event log window...
by amarnadh0203
Mon Aug 04, 2008 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage error
Replies: 9
Views: 3014

Thas only message i am getting ..nothing else....
by amarnadh0203
Mon Aug 04, 2008 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC stage error
Replies: 9
Views: 3014

ODBC stage error

I have a job design like below: ODBC Stage ----> Sequential file Stage ODBC stage with "BULK INSERT" and "SELECT 'ok' as RSLT" Sequential file Stage with input link for 'RSLT'. the job completes with FINISH status but logs a Fatal error listed below: Fatal Error: ODBC_Enterprise_...
by amarnadh0203
Tue Jul 29, 2008 12:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs running very longtime
Replies: 11
Views: 5057

Yes, the other processes are also giving the same details as of first one.

Could you please explain me in details...?
by amarnadh0203
Tue Jul 29, 2008 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs running very longtime
Replies: 11
Views: 5057

i got the following listed:

n431c7@tedshdu2 /home/n431c7 $ strace -p 18240
Process 18240 attached - interrupt to quit
[ Process PID=18240 runs in 32 bit mode. ]
futex(0x3dc820, FUTEX_WAIT, 2, NULL
by amarnadh0203
Tue Jul 29, 2008 10:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs running very longtime
Replies: 11
Views: 5057

"truss -p 20832" it days no such command.

Please provide any alternative.
by amarnadh0203
Tue Jul 29, 2008 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs running very longtime
Replies: 11
Views: 5057

i have seen the processes in the SQL server in "AWATING COMMAND" status for a long time ... i am also seeing processes in Linux server. Job remains in the Running status too. n431c7 20823 26610 0 11:36 ? 00:00:00 phantom DSD.RUN P444_04_RI_Control_Stat 0/0/1/0/0 n431c7 20832 20823 0 11:36 ...
by amarnadh0203
Tue Jul 29, 2008 8:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs running very longtime
Replies: 11
Views: 5057

Jobs running very longtime

Hi All, We are moving from 7.1R1 server environment to 7.5.2 parallel linux environment. In first phase we have migrated all our server jobs from 7.1R1 to 7.5.2 and did minimal changes to the jobs ex: environment variables, paths etc. As part of test we are running the jobs the jobs keeps running mo...