DSXchange

i. When you are talking to huge tables, try to INDEX it properly while doing a SELECT. Build and use proper indexes on your 40-70m records table.
ii. Not pretty sure, but Hash partitioning may help you in this scenario..

Here are the steps.. 1. Login as dsadm 2. cd into DataStage home directory. You can enter "cat /.dshome" to find the DataStage home directory 3. Enter ". ./dsenv" (i.e. .space./dsenv) to source the dsenv file 4. Enter "bin/uvsh". It will bring you into UV Administration...

The user i am using for Datastage has all the privileges.

Check the user which you are specifying in DB2 stage to connect to database, you did check DataStage user.

Raj,

Perhaps your database user lacks SELECT privilege on the system tables. Check with your DBA.

Hey guys, like Vincent probably you can also post some advices on exam preparation.. Will definitely be helpful to people like me who are still not prepared and confident to face the exam

Anupam, you got Murali wrong. How can he open the job when the problem itself lies in opening the job

Murali, did u import this job from any other project? May be Job Design is not taken when exported.

Sushil,

Can u post the Error/Warning messages that were thrown?
Would be good if you can post the issue with little more details, like whether you are able to compile the job, etc.

IBM support, North America

Hi Amar, First, you can try with SEARCH mechanism in this site. I kill 90% of the my queries looking at already posted topics. Second, you can use DB2 stage (preferably, and ODBC optionally) to point to a DB2 table. You need to have all the info required to connect to the database with proper author...

Vincent,

There can be reasons - like in our case, we have our target DB non-partitioned (it's DB2). We cannot use DB2 EE stage unless the database it is pointing to is partitioned. And that's what has been told by IBM support.

Hi Kumar: The cycle - You design in the designer. A Osh code will be generated. It can be compiled using compiler, it does while you compile before you run your job. And produces an executable. I am bit confused here. You said OSH code will be generated when you design the job and then it can be com...

Thanks Kumar!

The description is been very informative and helpful.

Hi All, We are all set to deploy our DS project into production. Now we have been told that the client doesn't allow to have C compiler in PRD server. They want to release the DS project as an executable. Project details in brief: a. Using Unix script to run the jobs b. Using a parameter file to pas...

Hi, We came across a situation where using DRS is advantageous over native stage for DB2. We are implementing NLS in one of our projects. Our source data come from AS/400 systems. In the source tables we have multi-lingual data across columns. DRS stage supports NLS at column level whereas DB2 stage...

Still getting those warnings.. We have the same set of jobs in two different environments, viz DEV and UAT. In both places, RCP is disabled at project level. In DEV, we get warnings in a couple of jobs while in UAT it troubles us in around 20 jobs, though the project in UAT is just a full import of ...