Search found 4605 matches

by kduke
Fri Apr 15, 2005 10:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgaradation from 6.0.1 to 7.5 or 7.5A?
Replies: 9
Views: 3882

We just upgraded to 7.5.1 and are having lots of problems. I hear 7.5 is very stable. When we isolate the problems then we will fill you in.

I am curious. Has anyone downgraded from 7.5.1 to 7.5 and what were the issues?
by kduke
Fri Apr 15, 2005 9:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Easy access of Job Description
Replies: 22
Views: 3744

There are several posts of routines to get the category. Do a search. Mine is called GetCategory().
by kduke
Thu Apr 14, 2005 6:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Purging of DataStage Log from Unix Script
Replies: 14
Views: 12853

I have tried doing this and you have to disconnect from DataStage and reconnect to see the change. Not cool. They are stored in RT_STATUSnnn. The log file has a field to specify which instance id this log record belongs to.
by kduke
Thu Apr 14, 2005 6:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: code migration problems
Replies: 3
Views: 959

1. Sort of because you may have defaluts on the parameters. I have seen where the parameter name was TargetDSN and they used TargetDsn at run time in a script ans also in a sequence and the proper value was never sent because the parameter name was invalid. 2. You don't. You can check the log afterw...
by kduke
Thu Apr 14, 2005 5:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Accessing Unix shell environment variables from serverjob
Replies: 5
Views: 2208

You need to source these into dsenv. You will need to stop and start DataStage afterwards.

Code: Select all

. FILEPATH/file_name.env
by kduke
Thu Apr 14, 2005 5:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can DS table definitions be converted to cobol file layouts?
Replies: 2
Views: 622

Ray posted a routine to convert them to XML. I think you should be able to modify this routine to convert them to anything you want.
by kduke
Thu Apr 14, 2005 5:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to output the tables from a output seq file to a file
Replies: 5
Views: 709

Sorry. The metadata in DS_METADATA does not effect the job. It may mess up MetaStage. You can delete it. You can import over it. This data is copied into the job whenever you load it. Afterwards all jobs are unrelated to this metadata except MetaStage keeps track of where you imported it from. You c...
by kduke
Thu Apr 14, 2005 9:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Easy access of Job Description
Replies: 22
Views: 3744

DS_JOBS, DS_JOBOBJECTS, RT_LOG and other similar hash files are where the actual data is stored. Arnd is correct these tend to change from one release to the next. You can generally read from these in routines but it normally will not let you write to them except in jobs. The SDK routines like DSGet...
by kduke
Thu Apr 14, 2005 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown file changes in DSEngine directory
Replies: 4
Views: 2131

This is normal. Do worry.
by kduke
Thu Apr 14, 2005 8:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Easy access of Job Description
Replies: 22
Views: 3744

You are probably correct but I have had lots of problems when developers attach to every job. Most think the detach is optional. This code will not live beyond this release either way. That is my bet.
by kduke
Thu Apr 14, 2005 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Select DS_JOBS not finding multiple instances
Replies: 4
Views: 1709

You will not be able to select these in the same select statement. You can call a routine to get the instance ids. There are several posts on this. You might want to search for them. There are also posts on dictionary items and routines on which job is a multiple instance job. Ray posted a routine l...
by kduke
Thu Apr 14, 2005 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Keys in Sequenrtial stage
Replies: 1
Views: 557

No problem and no impact. They mean nothing to a sequential stage.
by kduke
Thu Apr 14, 2005 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Easy access of Job Description
Replies: 22
Views: 3744

I would not attach to every job in your project this way. There are lots better ways to do this. ProgramName = 'JobName' JobHandle = DSAttachJob(ProgramName, DSJ.ERRFATAL) IF (JobHandle = DSJE.BADHANDLE) THEN CALL DSLogFatal('Fatal','') ShortDesc = DSGetJobInfo(JobHandle,...
by kduke
Thu Apr 14, 2005 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs hanging
Replies: 2
Views: 872

Certain versions of the Oracle9i client have memory leaks. Check with ASCL on your version.
by kduke
Thu Apr 14, 2005 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: swap filling while memory is still available
Replies: 7
Views: 3633

I think the command is shmtest. If you set these wrong then jobs core dump. Not good. If the command itself is wrong then I have problems as well. Are you sure this command is incorrect?