DSXchange

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...

Thanks for the clarification Craig.

I will mark this thread as RESOLVED.

Now to move on to getting Netezza Enterprise working

-Steve

Thanks Aruna,

Your solution was spot on!!!

Is this a Netezza specific thing, or is it associated to AIX? (this is a software trial we are currently working on a new AIX box rather than our usual HP-UX platform)

Thanks for the quick response.
-Steve

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 ...

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...

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 ...

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 ...

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 ...

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...

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 ...

Boris, I'm not following your "packed fields in hex format" line. How are you looking at the mainframe data? If you are using ISPF edit, then you need to enter "hex on" at the command line to see the hex representation of the data. Should look something like this: 121*....256<......

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...

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...

I agree 200% with "Parameterize everything". I hadn't played with the stage enough yet to realize the difference between fully generated and column generated. My DBA group is researching use of environment variables and tnsnames.ora file entries to help resolve the issue. Luckily we have a...

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...