Search found 183 matches

by trokosz
Mon Jan 31, 2005 8:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Structure of DS Tables -- DS_JOBS
Replies: 16
Views: 11581

Yes, I agree do not play with the RT_ files. I would assure there are no orphaned locks and all PIDs are killed. After that I would DS.REINDEX ALL. The I would try deleting.
by trokosz
Thu Jan 27, 2005 6:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What does this error message mean?
Replies: 6
Views: 3641

Config File Locations

You find the APT_CONFIG_FILE in one of two places:

1. Go to Manager go to Tools | Configurations and there they are....

2. Go to cd $DSHOME, up one cd../Configurations and there they are where you can cat or vi them...
by trokosz
Thu Jan 27, 2005 6:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to unlock a ds job using unix commands
Replies: 7
Views: 7182

Unlocking Jobs

I agree with others that unlocking Jobs and killing processes can cause issues so be aware and careful. In all cases make sure the impacted User gets out all together and unlock by UserID. But to unlock Jobs you can: 1. In DataStage Administrator there is a process thats defined in DSXChange already...
by trokosz
Tue Jan 25, 2005 10:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: database password changed
Replies: 17
Views: 4939

Never use absolute pathing....

All the responses have said enough. Never use absolute pathing but rather relative pathing by using .ini, .par or .config files.
by trokosz
Sat Jan 15, 2005 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What for DataStage on AIX platform needs C++ runtime library
Replies: 4
Views: 999

C++ and AIX

You need VisualAge C++ 5.0.2.0 for DataStage 7.1.....VisualAge C++ 6.0 for 7.1r2 and 7.5A.....Note: You need C++ and all its load libs...The runtime version only will not work... The reason as mentioned is to execute Parallel Jobs (Server Jobs do not require) but more specifically the only for Paral...
by trokosz
Thu Dec 16, 2004 12:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cleaning out Director log entries
Replies: 16
Views: 7089

Hey, I just tied to help concerning overriding and clearing a large Log file which I thought was asked....and I actually do not agree that this is a bad practice....but its an idea ....best of luck
by trokosz
Wed Dec 15, 2004 9:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hashed File in a Server Shared Container for read access PX
Replies: 10
Views: 3388

Your not do a parallel lookup in a shared container at all with a hash file...its serial....you take the performance hit you would have taken in a server job....or you gain nothing from the parallel job in this area....hash files are not in parallel jobs so you have no choice but a server job or sha...
by trokosz
Wed Dec 15, 2004 8:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Are there entries in logs equivalent to the perf stats?
Replies: 2
Views: 1465

There are several performance environment varaibles that can be set to make entries into the Log such as APT_RECORD_COUNTS.
by trokosz
Wed Dec 15, 2004 8:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hashed File in a Server Shared Container for read access PX
Replies: 10
Views: 3388

Server shared containers run in serial but if connected to other stages outside of the shared container will run in parallel as designed. Thats about it...
by trokosz
Tue Dec 14, 2004 8:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cleaning out Director log entries
Replies: 16
Views: 7089

Clearing the Log File

Using the DataStage Administrator, select the project and push the COMMAND button to bring up the command window. After that, enter the following command to find the job number. Note, the job name is case sensitive. LIST DS_JOBS WITH NAME="yourJobName" Look at the output and note the job n...
by trokosz
Mon Dec 13, 2004 6:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: restrict access to job
Replies: 2
Views: 846

Manipulate your Unix permissions accordingly....

All DataStage developers typically are a member of the GID (Group ID) of dsadm....and they may have a sub-group within to categorize them.... So for a Project you would set the permissions to be one GID and the second Project to be another GID....But Jobs within a project is difficult since permissi...
by trokosz
Wed Dec 08, 2004 9:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ds_loadlibrary: error in dlopen - Dynamic Error
Replies: 3
Views: 1950

Just pointing out an already answered question

Yes, I have come across the issue and yes I give credit to everyone else who pointed this out just like you could have done....congratulations to all and never meant to steal
by trokosz
Wed Dec 08, 2004 5:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can ds7 support AIX5.3?
Replies: 4
Views: 2340

No AIX 5.3 is not supported

DataStage 7.0.1, 7.1 and 7.5 all only support 5.2...
by trokosz
Wed Dec 08, 2004 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ds_loadlibrary: error in dlopen - Dynamic Error
Replies: 3
Views: 1950

I believe your dsenv file is not configured properly

Your dsenv file (in the DSEngine) is not properly setup to match your environment. It's telling you it can't find the client libraries (e.g., Oracle maybe). Double-check how your Environment variables are defined in dsenv (especially the SHARED LIBRARY PATH) and correct them to match this server. St...