Search found 53125 matches

by ray.wurlod
Thu Oct 01, 2009 1:04 am
Forum: IBM QualityStage
Topic: Stored Procedure
Replies: 6
Views: 2596

Perhaps you could post your question in the correct DataStage forum, then...
by ray.wurlod
Thu Oct 01, 2009 12:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to find the CPU and MEMORY USAGE
Replies: 4
Views: 1243

Don't use operating system commands. Instead, enable the pertinent environment variables to have the player processes log their memory and timing statistics, namely APT_PM_PLAYER_MEMORY and APT_PM_PLAYER_TIMING.
by ray.wurlod
Thu Oct 01, 2009 12:51 am
Forum: IBM QualityStage
Topic: Stored Procedure
Replies: 6
Views: 2596

In QualityStage?
by ray.wurlod
Wed Sep 30, 2009 8:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Hash file through Universe Stage
Replies: 21
Views: 5407

Looks like BEGIN_YEAR is not a column name in the table. Use your Administrator client command window to

Code: Select all

LIST.DICT TestNullValueLookup_HF
by ray.wurlod
Wed Sep 30, 2009 8:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: # inside field name
Replies: 5
Views: 1250

Moderator: please move to server forum
by ray.wurlod
Wed Sep 30, 2009 8:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: connecting to DB2 database from datastage unix server
Replies: 4
Views: 2306

"Not working" means unemployed.

Can't help with the second one.
by ray.wurlod
Wed Sep 30, 2009 7:52 pm
Forum: IBM QualityStage
Topic: List of QualityStage objects
Replies: 3
Views: 2095

DataStage and QualityStage are the same place in version 8, therefore the answer is DS_JOBS and DS_JOBOBJECTS. Files associated with provisioned rule sets are stored in directories on the server - from memory these are subdirectories in the project directory and have "quality" in their nam...
by ray.wurlod
Wed Sep 30, 2009 5:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compress Stage
Replies: 1
Views: 1246

Moderator: please move to Enterprise Edition forum
by ray.wurlod
Wed Sep 30, 2009 12:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue while starting the Server
Replies: 8
Views: 5703

Web Console for Information Server, in the area where you manage users. However, wasadmin needs to exist as an operating system user on the machine where the WebSphere Application Server is installed.
by ray.wurlod
Tue Sep 29, 2009 8:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No SQL catalog data for schema '' in UV_SCHEMA
Replies: 9
Views: 4169

OK. Well, the good news is that this won't affect your operations. The bad news is that it shouldn't be happening at all - could be a bug in VERIFY.SQL. Further investigation is required. As noted, these items should - correctly - have no entry in the SQL catalog. Typically the only UniVerse table a...
by ray.wurlod
Tue Sep 29, 2009 7:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kick a job with the changes in database table
Replies: 14
Views: 4551

As I see it you have two choices - to create triggers in the database that eventually invoke dsjob to run the DataStage job, or to have a DataStage job that polls the table in question as part of a sequence, perhaps.
by ray.wurlod
Tue Sep 29, 2009 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could DS be automatically reverting changes?
Replies: 6
Views: 2077

May I suggest a paper-based checklist for developers? That way you have an audit trail that you've completed all required steps. Another possibility is that Designer was closed without saving changes. There's no recovery from this. That's why I never use Tools > Options to disable prompting on delet...
by ray.wurlod
Tue Sep 29, 2009 7:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Write data to HTML
Replies: 3
Views: 1088

A final Transformer stage to add the HTML tags (at least the <tr> and <td> tags) might be feasible - although it would be like writing HTML with Notepad!
by ray.wurlod
Tue Sep 29, 2009 7:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No SQL catalog data for schema '' in UV_SCHEMA
Replies: 9
Views: 4169

Yes, but the header has been re-written and may no longer contain the reference to the SQL catalog.
by ray.wurlod
Tue Sep 29, 2009 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No SQL catalog data for schema '' in UV_SCHEMA
Replies: 9
Views: 4169

Try

Code: Select all

RESIZE RT_CONFIG1 * * *
then see whether the VERIFY.SQL report for that "table" is still awry.