Search found 25 matches

by chpraveen.msc
Tue Aug 11, 2015 1:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: getting error in datastage 11.3
Replies: 6
Views: 6063

No default type conversion from type "date" to typ

Hello All, I am running into similar issue. We are in a process of migrating from DS Version 8.5 to 11.3 As part of our testing, we have migrated some of our production code (8.5 )to 11.3 DS On of our job i failing with the below error in the transformer Stage Xfm_FIRM_MGT_BKR_ETL: When preparing op...
by chpraveen.msc
Tue Aug 24, 2010 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to load data to a DB2 Table
Replies: 3
Views: 3060

Hi Michael,
Thank you so much for your valuable inputs and apologies for the delay in my response. I checked with the Admin team and there happens to be a Fix patch upgrade on one of the DS server. I am assuming that the issue was becasue of the upgrade.

DSX rocks :D !!!
by chpraveen.msc
Fri Aug 20, 2010 7:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to load data to a DB2 Table
Replies: 3
Views: 3060

I tried running the respective job with a PEEK stage and job is running fine. But when i swap it with the DB2 Enterprise stage its giving the above Fatal warning. I have pasted the OSH dump reference. Please help me in resolving the issue. OSH script # OSH / orchestrate script for Job CopyOfLoad_MED...
by chpraveen.msc
Fri Aug 20, 2010 7:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to load data to a DB2 Table
Replies: 3
Views: 3060

Unable to load data to a DB2 Table

Hi all, I have a very simple job which load data to a Target DB2 TABLE reading data from a Dataset. Job was running fine till some time back. All of the sudden the job is getting aborted with the below fatal Error. main_program: Internal Error: (k == numNodes): db2partutils.C: 773 Traceback: pureAss...
by chpraveen.msc
Thu Aug 19, 2010 10:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to DataStage
Replies: 9
Views: 7329

DSX .....ROCKS :lol: Thanks Craig
by chpraveen.msc
Thu Aug 19, 2010 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to DataStage
Replies: 9
Views: 7329

Experts can you please put me out of the confusion.... and helep me understand the process. :(
by chpraveen.msc
Thu Aug 19, 2010 10:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to DataStage
Replies: 9
Views: 7329

Sainath and hari Thanks for your valuable inputs. I still have a some confusion based on your replies. Per Sainath: 45 client license means 45 different users( with different ip address) can login at any give time. Does it mean if user1 opens 5 differnet client tools (say 2 designer,1 director and 1...
by chpraveen.msc
Thu Aug 19, 2010 12:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to DataStage
Replies: 9
Views: 7329

Hi All i am facing a similar issue. We have a big team at offshore accessing the servers through citrix (users) -----Citrix-----> (Client) <-----> (Engine) After certain number of user login to the server through(sorry i was not able to give the exact number). We are not able to create new session. ...
by chpraveen.msc
Fri Aug 13, 2010 5:59 pm
Forum: General
Topic: Differnect between various 'ps-ef' commands
Replies: 6
Views: 3257

Thanks Craig....I missed them in the search.
Appreaciate your timely help.
by chpraveen.msc
Fri Aug 13, 2010 5:36 pm
Forum: General
Topic: Differnect between various 'ps-ef' commands
Replies: 6
Views: 3257

Pardon me for the typo. i mean "dscs" Not "dscds"
by chpraveen.msc
Fri Aug 13, 2010 2:35 pm
Forum: General
Topic: Differnect between various 'ps-ef' commands
Replies: 6
Views: 3257

Hi Craig,
Thank you so much for your quick respones. I think i have put the question in a wrong way.

Can you please let me know the differnec between the various process. and what exactly are they?

1.dscds
2.dsapi
3.dsrpcd
by chpraveen.msc
Fri Aug 13, 2010 1:47 pm
Forum: General
Topic: Differnect between various 'ps-ef' commands
Replies: 6
Views: 3257

Differnect between various 'ps-ef' commands

Hi All,
It may be a dumb question for many,I Request all to Please let me know the difference between the below list of unix PS COMMANDS commands.

1. ps -ef|grep dscs
2. ps -ef|grep dsapi
3. ps -ef|grep dsrpcd.

Thanks in advance.
by chpraveen.msc
Thu Dec 17, 2009 7:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to Run Resource Estimation in Datastage PX job
Replies: 1
Views: 5573

Item #: 69 Event ID: 68 Timestamp:: 2009-12-16 17:40:01 Type: Info User Name: dsadm Message:: ora_Edw_FinProdMap,3: Records inserted: 0 Records used for update: 79,027 Records rejected: 477 Total records: 79504. Item #: 70 Event ID: 69 Timestamp:: 2009-12-16 17:40:05 Type: Info User Name: dsadm Mess...
by chpraveen.msc
Thu Dec 17, 2009 7:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to Run Resource Estimation in Datastage PX job
Replies: 1
Views: 5573

Not able to Run Resource Estimation in Datastage PX job

Hello All, Currently we are in a process of tuning the Datastage ETL code to meet out SLA time lines. I thought , running the "Resource Estimates" and "Peformance Analysis" will give us a good idea, on where the bottle neck is, in a given ETL job. I am not able to run "Resou...
by chpraveen.msc
Thu Oct 09, 2008 2:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help in setting Null value..
Replies: 9
Views: 5498

Hi Ray,
Thanks for your reply, I am using DB2-API stage to load the data. Actually there was a trigger on the table which will convert NULLS to a default value, which i overlooked.
Now my issue was resolved. @NULL works perfectly fine.