Search found 82 matches

by deanwalker
Tue Jun 17, 2008 2:13 am
Forum: General
Topic: DSR.ADMIN: Error creating DR elements, Error was -1
Replies: 7
Views: 7472

DataStage failed to create all the required project records in XMETA, you will not be able to create a project with this name until these are removed. If you can live with another project name, then that is a workaround. You will need help from support to remove the existing items if you require to ...
by deanwalker
Mon Jun 16, 2008 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error writing to ROOT
Replies: 5
Views: 3700

I suggest you check the WAS logs for errors, you may find something relevant to this job. I believe that the XMETA representation of the job has become corrupt, and that you will need help from your support provider to remove the job from XMETA, and restore from a backup.
by deanwalker
Sat Jun 07, 2008 4:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where to find job schedule info in xmeta DB?
Replies: 14
Views: 16704

There is no scheduling info in XMETA, this info is in the executable job (RT_CONFIGnn), so is in the DS Server Project.

I don't think you can drive dssh from a file, but the same logic in a UV BASIC program would be reasonably simple, or use the dsjob api to get the lists of jobs and scheduling info.
by deanwalker
Thu Jun 05, 2008 2:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where to find job schedule info in xmeta DB?
Replies: 14
Views: 16704

The information that is in the DSX of an executable job for scheduling is in the record "JOBSCHEDINSTS" of RT_CONFIGnnn. And the parameters are in JOBPARAMINSTS. The records are not present if the job has not been scheduled. I can see these records using "CT RT_CONFIGnnn JOBSCHEDINSTS...
by deanwalker
Wed Jun 04, 2008 2:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where to find job schedule info in xmeta DB?
Replies: 14
Views: 16704

You can see that information in the RT_CONFIGnnn file, or export the executable and it is visible in the DSX too.
by deanwalker
Wed May 28, 2008 3:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable in column derivation of the transformer
Replies: 10
Views: 3101

I think a 'workaround' is what you do to get a process to work while reporting the bug to support and waiting for a fix.
Several times in the past I have had to protect calls to APIs that were not checking for bad arguments, whilst also reporting the API crashes to the vendor.
by deanwalker
Tue May 27, 2008 1:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable in column derivation of the transformer
Replies: 10
Views: 3101

Same answer:
You can't use an environment variable 'there'.
The workaround is to use GetEnvironment("envvarname")
by deanwalker
Tue May 27, 2008 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Parellel transformer using Env Variable
Replies: 1
Views: 2142

You can't use an environment variable 'there'.
The workaround is to use GetEnvironment("envvarname")
by deanwalker
Wed May 21, 2008 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage scheduler not showing scheduled jobs
Replies: 8
Views: 4819

I believe your user needs read & execute access to /usr/spool/cron/atjobs
by deanwalker
Wed May 14, 2008 2:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS jobs
Replies: 13
Views: 4349

Search for 'dsjob', this is used to run jobs from the command-line, specifying server,project,job,parameters,...
by deanwalker
Sun May 04, 2008 2:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Couldnt able to see the Code
Replies: 4
Views: 1659

Or they might have broken the ability to see it inadvertantly, and be fixing it for 8.1.
by deanwalker
Fri May 02, 2008 5:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage 8 installation error
Replies: 8
Views: 3844

Delete the InstallShield folder:
C:\Program Files\Common Files\InstallShield\Universal\IBM\InformationServer
by deanwalker
Mon Apr 21, 2008 2:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Root created and cant delete it
Replies: 9
Views: 5892

You definitely need help from Support for this, to get your repositories in a consistent state after removal of the ROOT data.
by deanwalker
Thu Apr 17, 2008 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSX stage names to meaningful stage names
Replies: 10
Views: 13074

Anything that ends Input or Output is likely to be the appropriate end of a Link.
by deanwalker
Tue Apr 15, 2008 2:43 pm
Forum: General
Topic: DataStage User Login
Replies: 5
Views: 6131

Re: DataStage User Login

All, 4. When I changed the password for Windows login, DataStage Client does not allow me to enter into DataStage using "Omit"(I used to enter DataStage using this option before changed the password). Upto my knowledge, DataStage checks the old passeord with the new one and throws an erro...