Search found 57 matches
- Tue Oct 23, 2012 1:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex XML generation failure at high data volumes
- Replies: 0
- Views: 1191
Complex XML generation failure at high data volumes
Hello, My client is facing an issue with running a complex XML generation job when row volumes go above about 10,000. The job reads data from an Oracle source which contains flattened data about a composite customer (dealers/suppliers/"individual customers"). The data is passed through a t...
- Tue Sep 30, 2008 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9586
- Tue Sep 30, 2008 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9586
- Tue Sep 30, 2008 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IS connectivity to Netezza error
- Replies: 6
- Views: 9586
IS connectivity to Netezza error
Hello, I'm currently working on configuring Information Server to work with Netezza. Just trying to start with a simple :lol: ODBC connection to the Netezza machine. I have installed the Netezza 4.5.0 ODBC drivers to the following location : /as_edw_wwt03/Netezza/npsclient450 Here is the content of ...
- Wed Aug 18, 2004 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS JCL Job to reset all jobs in a category, pls. critique
- Replies: 9
- Views: 6544
CYH, The code you found with Ray's additions would be fine if you know the exact job names at the time of execution. We use controlling jobs to initiate streams of DataStage jobs. All of the particular jobs for a given stream are all saved within the same category(gui folder) in a project, and at an...
- Mon Aug 02, 2004 3:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS JCL Job to reset all jobs in a category, pls. critique
- Replies: 9
- Views: 6544
You were right Ray! That code wouldn't reset anything. There is an error in the DSRunJob and DSWaitForJob, I used the variable ParsedJob rather than the correct AttachedJob. Only took a few minutes of head scratching to find that one :lol: . In director this returns within one second for a no-reset ...
- Sat Jul 31, 2004 7:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS JCL Job to reset all jobs in a category, pls. critique
- Replies: 9
- Views: 6544
Thanks for the info Ray, I will make the change from runwarn to valfailed. I had intentionally left out the status check of the reset. I want this job to never fail since it will be run in every production job. The purpose of this is to allow easier after hours support of production jobs when users ...
- Fri Jul 30, 2004 10:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Job to connect to DB2 on mainframe
- Replies: 7
- Views: 5338
Carol, Here's the entries from our dsenv file: # DB2 7.1 PLATFORM SPECIFIC SECTION DB2DIR=/opt/IBMdb2/V7.1 DB2INSTANCE=db2inst1 INSTHOME=/db2_con/db2inst1 THREADS_FLAG=native export DB2DIR export DB2INSTANCE export INSTHOME export THREADS_FLAG SHLIB_PATH=$SHLIB_PATH:$INSTHOME/sqllib/lib:$DB2DIR/lib ...
- Fri Jul 30, 2004 9:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS JCL Job to reset all jobs in a category, pls. critique
- Replies: 9
- Views: 6544
DS JCL Job to reset all jobs in a category, pls. critique
Morning all, I am working on a process to add to all of our production jobs that call DataStage from UNIX scripts using the dsjob command. Within our architecture we have created projects for each subject area (order/invoice, material management, finance,...). We then use categories to group all the...
- Fri Jul 30, 2004 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Job to connect to DB2 on mainframe
- Replies: 7
- Views: 5338
Carol, We are using the UDB/DB2 stage on a HP-UX server to connect with DB2 on the mainframe using DB2Connect. We are running DS UNIX server version 5.2r5 and 7.1r1 and both are working correctly. As I recall, the connection setup was troublesome but not impossible. The DB2 stage does not require a ...
- Thu Jul 22, 2004 2:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Packed decimal
- Replies: 8
- Views: 4131
- Thu Jul 22, 2004 1:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Packed decimal
- Replies: 8
- Views: 4131
Boris, This definition is not for packed decimal or even binary. The data on the mainframe should look a little strange when you look at it in an edit session. For example, the actual value +1215 would look something like 121* ( the * may be some other character depending on the opnes position ). Th...
- Thu Jul 15, 2004 1:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Strange behaviour of uvodbc.config file
- Replies: 3
- Views: 3695
One way around this is to create a symbloic link between the project(s) uvodbc.config and the DSHOME uvodbc.config. i.e. on HP-UX 11 (make sure you backup the existing project uvodbc.config file :wink: ) ln -s ~/Ascential/DataStage/DSEngine/uvodbc.config uvodbc.config Execute this from within the in...
- Thu Jun 24, 2004 1:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle 9i odbc driver configuration HP-UX ****RESOLVED****
- Replies: 13
- Views: 7752
- Thu Jun 24, 2004 1:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle 9i odbc driver configuration HP-UX ****RESOLVED****
- Replies: 13
- Views: 7752
Never in a million years would I have guessed that the connection would be that simple. :o :lol: :P Any suggestions for eliminating the requirement of fully qualified path names to tables on remote servers. Within our environments the development owner is different from the production owner. Therefo...