DSXchange

Thanks for clarifying. I just checked and orchdbutil is installed on our USS system so now it makes more sense why I was able to use Orchdbutil against DB2 z/OS in my USS project, but not my server project. So, basically, I need to stop trying to get Orchdbutil to work in my server project. I'll use...

We are successfully running PX jobs on a unix AIX server to access DB2 z/OS using the DB2 API plug-in. The problem I'm experiencing is that I can't seem to get my Import , Table Definition, Orchestrate schema definitions to successfully connect to DB2 z/OS in a server project. When I am in a USS (un...

Can someone tell me if the bind and grant for db2esql is required for DB2 z/OS? The Enterprise Edition installation indicates that the db2setup.sh and db2grant.sh must be run to bind dsadm.db2esql. What I have found is that not all of the DB2 install related steps are relevent if you are using DB2 o...

Using DataStage PX, I am trying to figure out how to do the following: I have 2 files that I need to merge together such that all records from File 1 and File 2 are written out UNLESS there is a match between the 2 files (key: Billing#, Ship#, Item#). If there is a match, only the 2nd File's version...

Just wanted to let you all know how we got our problem fixed.

There is an environment variable APT_ORACLE_NO_OPS that can be set to 1 which will tell Ascential not to check for the existence of the table SYS.GV_$INSTANCE. Once this was added to our Job, it ran fine.

I am new to Ascential and just starting to develop Parallel Jobs. I am getting the following error message when trying to run a Parallel Job using the Oracle Enterprise Stage (Oracle9 plugin). Prepare failed for: GenericStmt_3 query is: select count(*) from sys.gv_$instance sqlcode is: -942 esql com...