Search found 297 matches

by jhmckeever
Fri Jan 26, 2007 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Avoid Instances--SH -c "dsjob -ljobs <Project> |
Replies: 7
Views: 2024

Hmm - My dsjob -ljobs just returns job names. Invocations are returned by dsjob -linvocations. Assuming your "dsjob -ljobs" is returning a list of JOBNAME.INVOCATIONID lines (!?), you can de-duplicate and count lines like this: SH -c "dsjob -ljobs <project> | cut -d'.' -f1 | uniq | wc...
by jhmckeever
Fri Jan 26, 2007 10:23 am
Forum: IBM QualityStage
Topic: how to deply quality stage job in unix
Replies: 4
Views: 3484

Hi, How do we deploy a qualiy stage job in unix You select a job, right-click and select 'Run' (or use the appropriate icon on the toolbar.) In the resulting dialog, under 'Run Select Options' select the 'Deploy' checkbox. If you only want to deploy (not run) uncheck the 'Run' checkbox. Then execute...
by jhmckeever
Thu Jan 25, 2007 11:54 am
Forum: IBM QualityStage
Topic: how to look for the directory in quality stage
Replies: 5
Views: 4342

Sorry... The code block above is a directory structure. 1. Choose somewhere sensible to keep you QualityStage projects on your server. (E.g. /home/qsadm/QSProjects) and create a run profile that uses this directory as its Master Project Directory. 2. Create a project, and define a Datafile definitio...
by jhmckeever
Thu Jan 25, 2007 11:30 am
Forum: IBM QualityStage
Topic: how to look for the directory in quality stage
Replies: 5
Views: 4342

QualityStage files must reside in the Data directory within the relevant project directory. These project directories are under your Master Project Directory. E.g. MyMasterProjectDiretory PROJECT1 PROJECT2 Controls DIC Data DATA1IN DATA1OUT DATA2IN DATA2OUT IPICFG Logs Scripts Temp PROJECT3 PROJECT4...
by jhmckeever
Thu Jan 25, 2007 5:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does ETL able to handle TCP Socket connectivity
Replies: 6
Views: 3588

Very true - Because the OP was rather vague in its intent I interpreted the question more broadly than referring only Server jobs. For the record, the example I gave is also used in server jobs by using named pipes (as Ray rightly suggested) and kicking off the client application using a Before-Job ...
by jhmckeever
Wed Jan 24, 2007 12:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does ETL able to handle TCP Socket connectivity
Replies: 6
Views: 3588

Hi thirupri, Without wishing to sound rude, your question really doesn't make much sense. <a href="http://en.wikipedia.org/wiki/Extract,_transform,_load">ETL</a> is a process used in Data Warehousing (or other data migration activity) whereas TCP sockets are a network communications mechan...
by jhmckeever
Wed Jan 24, 2007 10:00 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: PSDB
Replies: 1
Views: 3084

This is entirely possible, and is even documented in the manuals. Check the numerous examples in the "Configuration Examples" section of your PS Installation manual. Take a look at the ones ending "... Central PSDB". NOTE : Multiple Analysis Servers makes sense, but you only requ...
by jhmckeever
Mon Jan 22, 2007 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status of JobMonApp
Replies: 6
Views: 4695

*** This reply comes approx. 10 months after the original post ***

For anyone interested in this, you might want to search for the registered JobMonApp process, recorded in $APT_ORCHHOME/java/.jobmonpid :

Code: Select all

ps -ef | grep `cat $APT_ORCHHOME/java/.jobmonpid` | grep -v 'grep'
HTH,
J.
by jhmckeever
Mon Jan 22, 2007 12:07 pm
Forum: Site/Forum
Topic: Forum Etiquette - Should I Answer Old Posts?
Replies: 4
Views: 4169

Thanks Guys, Thanks for the clarification - I'll answer old posts as necessary, then, being clear that the OP is old. As product-related forums (or is that "fora"?) go, DSXchange is fantastic, so the last thing I wanted to do was abuse it in any way. I wonder if IBM are aware of how much v...
by jhmckeever
Mon Jan 22, 2007 11:44 am
Forum: Site/Forum
Topic: Forum Etiquette - Should I Answer Old Posts?
Replies: 4
Views: 4169

Forum Etiquette - Should I Answer Old Posts?

Hi All, Could someone clear up an etiquette issue for me? I sometimes stumble upon old postings for which there is no answer, but for which I feel I could make a worthwhile contribution. My question is, should I respond to these postings? For example, I've just found a posting that is almost 1 year ...
by jhmckeever
Thu Jan 18, 2007 5:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting List of job names from script.
Replies: 5
Views: 1269

Use the following command:

Code: Select all

dsjob -ljobs <project>
You might find the other options useful (Type dsjob with no parameters for a list)

HTH
J.
by jhmckeever
Wed Jan 17, 2007 10:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DW Certifications
Replies: 14
Views: 5356

Hema,

When I <a href="search.php">searched</a> DSXchange for 'certification' I got 95 matches.

Do those posts not answer your questions?

J.
by jhmckeever
Wed Jan 17, 2007 4:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Weird Error
Replies: 4
Views: 2003

DS_OBJECTS may have missing entries due to a problem saving the job. Does this problem apply to only one job or to many?

Are you hitting diskspace limits in your project directory?
Do you have a backup export of this job?

HTH,
J :-)
by jhmckeever
Fri Jan 05, 2007 10:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: launch the same job with different parameters
Replies: 3
Views: 2556

Also bear in mind it might be possible (depending upon your database configuration) to just pull the DBMS metadata in a single query. E.g. in Oracle:

Code: Select all

SELECT
   table_name, num_rows 
FROM
   tabs
WHERE
   table_name IN ('table1', 'table2', etc.);
HTH,
J.
by jhmckeever
Wed Jan 03, 2007 8:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Utilization of CPU
Replies: 9
Views: 5239

Allocating physical resources to processes is one of the main functions of an operating system. If you tell us WHAT you want to achieve (rather than HOW you were planning on doing it) we might be able to help? Where did the 50% and 30% figures come from?