Search found 36 matches

by LenGreenwood
Wed Apr 15, 2009 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot import server routine DS 8.0 in DS 8.1
Replies: 25
Views: 13455

It's for import of DSX files only.

You might want to check out the new Asset Import/Export capabilities of Information Server 8.1. And the ISManager tool. These use a new format, not DSX though, as they apply to more than just DataStage artifacts. So can't handle stuff from before 8.1.
by LenGreenwood
Wed Mar 18, 2009 3:47 am
Forum: General
Topic: Error while saving Parallel jobs & Compiling
Replies: 4
Views: 3192

A number of errors appear on the client for which you really need to see a Java stack trace to find the root cause. If you look in the C:\Documents and Settings\ Windows_Username \ds_logs directory you should find files named like dstage_wrapper_trace_NN.log (where N cycles from 1 to 20, to give you...
by LenGreenwood
Wed Mar 18, 2009 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot import server routine DS 8.0 in DS 8.1
Replies: 25
Views: 13455

8.1 has a command that you run on the server - DSXImportService.bat or DSXImportService.sh, depending on whether it is Windows or Unix.
In C:\IBM\InformationServer\ASBNode\bin by default.
by LenGreenwood
Fri Jan 23, 2009 3:48 am
Forum: General
Topic: DatStage showing DSCAPIOP_OraDB Error
Replies: 5
Views: 3191

If this is a parallel job and it calls a shared container, it may be a compiler bug. There is an APAR # JR29478 that resolves a very similar error message where "DSCAPIOP_ " appears as part of the param name.
by LenGreenwood
Thu Jan 22, 2009 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning: Configuration file not set
Replies: 1
Views: 1323

If the "Execution mode" box on the Advanced tab says "Parallel", the stage will run in parallel. The number of nodes it uses depends on the config file it is given at run time, not design time (that's what the $APT_CONFIG_FILE parameter gets used for). The bit of the Advanced tab...
by LenGreenwood
Thu Jan 22, 2009 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .dsx file
Replies: 2
Views: 2005

DSX files are created on the client (that is the same machine you are running the Designer on) in any location you choose to give to the export dialog. If you create a DSX file by running the dsexport.exe command, again you specify where you want to create the file on the local (must be Windows) sys...
by LenGreenwood
Thu Jan 22, 2009 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing Universe table definitions
Replies: 4
Views: 2583

Files whose Description field (in the VOC entry) contains certain strings, such as "DataStage", get filtered out early on in the process.
by LenGreenwood
Fri Jan 16, 2009 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Audit routines
Replies: 5
Views: 3258

Have a look at the MatchField() function or the Matches operator in the BASIC Reference Guide. Note that this uses different pattern syntax from what you may be used to - it is not the same as "regular expressions" you find in C etc. Something like If string Matches "0X'src'" The...
by LenGreenwood
Wed Jan 14, 2009 6:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Audit routines
Replies: 5
Views: 3258

Assuming what you want to do is find the names of all links of all stages in a job, and can then use pattern-matching on the link names to decide which ones to call via DSGetLinkInfo - e.g. ending in "_src" or "_tgt" or somthing like that:- DSGetJobInfo(JobHandle,DSJ.FULLSTAGELIS...
by LenGreenwood
Wed Jan 14, 2009 4:23 am
Forum: General
Topic: Routine Argument maximum size
Replies: 8
Views: 3703

DSEngine's Virtual Machine will have an upper limit of about 2GB on the length of a string variable that it can represent. In practice you don't get near that because of physical limitations, as Ray said.
by LenGreenwood
Tue Jan 13, 2009 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence - Possibility of Shell Script
Replies: 20
Views: 9925

Yep, post the code or a DSX & I can probably interpret it for you. Only way to trace this sort of thing, that I can think of, would be to put Routine stages into the sequence between other stages, using calls to UtilityMessageToLog to log messages containing the actual values of various job vari...
by LenGreenwood
Tue Jan 13, 2009 4:33 am
Forum: General
Topic: Job Report Folder
Replies: 3
Views: 3137

Actually at 8.x, job reports generated from the Designer get sent to the reporting service and end up stored in the repostory database. They aren't held in the Unix file system directly, the report contents are held a column in a database table (e.g. DB2) defined as a blob.
by LenGreenwood
Fri Jan 09, 2009 4:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence - Possibility of Shell Script
Replies: 20
Views: 9925

Hmm - it sounds as if the sequence should now be designed to do what you want, so we are back to why 2 triggers fire & 2 jobs run instead of one. If you can post a DSX export of the sequence here I could take a look. Or, you might look yourself at the generated code which will be in the job cont...
by LenGreenwood
Thu Jan 08, 2009 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence - Possibility of Shell Script
Replies: 20
Views: 9925

The trigger tab of a job activity stage is an expression that fires after the job has run. Sounds like your expressions need to be on the triggers of the Execute Command stage, not the job activity. Those fire after the command is executed, to decide whether execution proceeds to the next stage (the...
by LenGreenwood
Thu Jan 08, 2009 4:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Chinese Characters
Replies: 21
Views: 18863

From your original mail, it sounded like the character set of the data you are reading in the job was UTF-8. You should not change the project or job maps to say MS-936-CS, in that case. If you do, you are telling DataStage that the *data* is in code page 936, when it is not - it is in UTF-8. (The r...