Search found 15603 matches

by ArndW
Fri Jul 31, 2009 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RAM not getting released on Datastage server
Replies: 4
Views: 2270

The memory (M) page of NMON will show you some relevent information, but you need to know where to look and it does not give you process-based virtual memory usage details. A screenshot might help here, or the values for Min/maxperm, Min/maxfree, Pinned. But there is no direct correlation visible on...
by ArndW
Fri Jul 31, 2009 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job cannot get right parameter when scheduled
Replies: 9
Views: 2225

I doubt that your database is called "-1". So the question is how does your real database name get replaced with "-1"? Are you using a fixed name or are you using a project level parameter value (i.e. $PROJDEF)?
by ArndW
Fri Jul 31, 2009 2:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rcp doesn't work correctly
Replies: 11
Views: 2914

Jobs that write to a database and never finish usually (don't) do so because of database locks or deadlocks.
by ArndW
Fri Jul 31, 2009 1:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Character  converted to A
Replies: 7
Views: 3010

ArndW wrote:Do you have NLS settings in your $DSHOME/uvconfig file? If not, then NLS is not enabled.
you should have read access to this file.
by ArndW
Fri Jul 31, 2009 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job cannot get right parameter when scheduled
Replies: 9
Views: 2225

Perhaps your problem is different from what you expect. Could you post the actual error message?
by ArndW
Fri Jul 31, 2009 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass an entire SQLQuery as a parameter, in userdefined sql?
Replies: 3
Views: 1227

Yes, the user-defined query can be a parameter. You just have to ensure that the column names and number of columns returned matches.
by ArndW
Fri Jul 31, 2009 1:40 am
Forum: General
Topic: Repository details
Replies: 2
Views: 1014

At Version 7 and before, the repository is stored in hashed files, at Version 8 the repository is shared between hashed files and tables in a relational database.
The "server" is not connected to the project, it is the project. Clients are connected via sockets.
by ArndW
Fri Jul 31, 2009 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RAM not getting released on Datastage server
Replies: 4
Views: 2270

Which part of NMON are you using to determine memory usage?
by ArndW
Fri Jul 31, 2009 1:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage buffer issue
Replies: 2
Views: 5077

If you specify the 1000% then the system won't use that, but some default value. Are you sure that the disk write increment is the same size as your maximum? I've only heard the term "low water mark" referring to memory allocation on AIX systems, not as part of DataStage.Where does that er...
by ArndW
Fri Jul 31, 2009 1:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job cannot get right parameter when scheduled
Replies: 9
Views: 2225

The first entry in the job run log displays the parameters that are passed in - do they look as you expect for the non-password fields? I don't recall how to list "AT" style windows batch entries, but I'm sure you could call up the help to see which option will display the AT entries and w...
by ArndW
Thu Jul 30, 2009 10:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Aborting with @ABORT.CODE = 1
Replies: 12
Views: 6160

Can you do a recompile and see if the source appears?
by ArndW
Thu Jul 30, 2009 10:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Aborting with @ABORT.CODE = 1
Replies: 12
Views: 6160

You went into the BP.O subdirectory, not the BP one. The "O" stands for Object :)
by ArndW
Thu Jul 30, 2009 10:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector - SYSIBM.SYSDUMMY1
Replies: 4
Views: 3187

Perhaps it gets filtered from the dropdown list. Try to use the table in job and see what your error message(if any) is.
by ArndW
Thu Jul 30, 2009 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Aborting with @ABORT.CODE = 1
Replies: 12
Views: 6160

What does TRANS1 do? You could look at the source file around line 95, located in your project directory under RT_BP99/JOB.9809447.DT.1502744529.TRANS1
by ArndW
Thu Jul 30, 2009 9:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Aborting with @ABORT.CODE = 1
Replies: 12
Views: 6160

The message you posted looks like it came from a sequence, you should reset the actual job that aborted to get the abort cause in the "from previous run..." entry.