Search found 1315 matches

by PaulVL
Sun May 05, 2019 7:20 pm
Forum: General
Topic: DSODB - Is there a DSODB data dictionary?
Replies: 6
Views: 5621

Does anyone still have the PDF files that used to be on these links? http://www.ibm.com/developerworks/data/library/techarticle/dm-1207configtuningdatastage/index.html?ca=dat http://www.ibm.com/developerworks/data/library/techarticle/dm-1205datastageopsdb1/dm-1205datastageopsdb1-pdf.pdf http://www.i...
by PaulVL
Thu Apr 25, 2019 9:35 pm
Forum: General
Topic: Modified parameter value wont refresh in DataStage client
Replies: 3
Views: 3723

I have not personally seen that either, but then again, I'm not a developer.

Try doing a repository refresh, then look at the value.
by PaulVL
Mon Apr 22, 2019 4:10 am
Forum: General
Topic: FastTrack -- location of isx files
Replies: 1
Views: 2194

Well, the tool is not made the way you envision it. An ISX file can be located anywhere during it's load process. The contents once loaded into the tool, are no longer dependent upon the presence of that isx load file, meaning you can deleted it. The content of your DataStage repository COULD contai...
by PaulVL
Fri Feb 15, 2019 5:07 am
Forum: General
Topic: Need to get Object list from Package (.pkg) file
Replies: 6
Views: 5489

Well, like I said, I use an ISX file not a package.

I also don't have enough info as to how you had set up your environment.

Do you have a funcation authfile?

message me privately with the full command syntax you are using.

Send me the full error message as well.
by PaulVL
Wed Feb 06, 2019 8:10 am
Forum: General
Topic: Need to get Object list from Package (.pkg) file
Replies: 6
Views: 5489

We don't use packages here, we simply use isx files. Here is what I do to get a list of what the ISX contains. shell script command: jobList=`$DSHOME/../../Clients/istools/cli/istool.sh import -domain $host:$port -authfile /$userName/.datastage.authfile -archive $isxFile -preview -datastage "$h...
by PaulVL
Wed Feb 06, 2019 7:41 am
Forum: General
Topic: 11.5.0.2 Installation failing in WAS cluster server
Replies: 2
Views: 2877

Might want to double check your version of python on the host, and look at your default system settings for user id resources. the "ulimit -a" stuff. Make sure your file handle quantity is up to snuff. Another gottcha I found was the "nosuid" setting on the mounts (see /etc/fstab).
by PaulVL
Mon Jan 28, 2019 5:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel DataStage Jobs Hanging Intermittently - Oracle?
Replies: 11
Views: 9713

Is your environment set in a grid where the nodes get distributed to different hosts? Or do you have a consistent hard coded APT file?
by PaulVL
Mon Jan 28, 2019 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container can't open project after migration from 8.5
Replies: 9
Views: 5530

sometimes during a migration things hiccup and it's sometimes best to simply make a new container from scratch. I would rename the existing container. Create a new container (not a copy of process), and drag new stages onto the canvas and repolulate with the desired logic. Recompile container, (forc...
by PaulVL
Fri Jan 25, 2019 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container can't open project after migration from 8.5
Replies: 9
Views: 5530

In your shared container, there must be some code (basic?) that is making a call to open a project/job.

Can you show us what you are doing there?
by PaulVL
Mon Jan 21, 2019 6:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container can't open project after migration from 8.5
Replies: 9
Views: 5530

Well, is your environment the same as it was before? (stand alone host vs grid or cluster)

Are any other jobs broken or just this one?

Can you show the code that actually loads the other project code?
by PaulVL
Wed Jan 16, 2019 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Runtime comparision of tables using TD connector stage?
Replies: 8
Views: 4824

Do you have to validate each row or does a "sampling" suffice? You can extract from a table (based upon keys) sort the data and then instead of dumping to a sequential file all of that data, you could output a checksum value. Then just compare both checksums. Another option is load system ...
by PaulVL
Fri Jan 11, 2019 12:06 pm
Forum: General
Topic: Create users command line
Replies: 1
Views: 2060

If there was a command like that it would be "root" associated.

(The Australians will get the joke.)

===========

Please explain what you mean by creating a user.

Do you mean granting access to a user to a particular project and assigning a role?
by PaulVL
Fri Dec 14, 2018 7:21 am
Forum: General
Topic: Is it possible to hide project in datastage client
Replies: 2
Views: 3372

You could install two instances of DataStage on the same server and have them log in to their respective version. Or you could simply tell your customers that "In order to lower cost of ownership and to obtain a lower end cost for you, I have placed your project upon a shared resource. Capacity...
by PaulVL
Tue Nov 20, 2018 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 12c Update Jobs are failing with deadlock
Replies: 2
Views: 2959

Ask the DBA if compression was introduced to the database when you went to 12c.
by PaulVL
Tue Nov 20, 2018 8:58 am
Forum: General
Topic: Automated deployments using Team Foundation Server?
Replies: 4
Views: 4564

Why compile objects on your target hosts when you can deploy the executables in the isx file?

istools.sh should be used to import/export your jobs (isx format) via the command line.