DSXchange

IIS 8.0.1 Wrapped Stage for UNIX I have a unix command that works in a server routine and returns a timestamp: Call DSExecute("UNIX",'echo `date "+%Y%j%H%M%S%M"`', Output, SystemReturnCode) This needs to be converted to our IIS 8.0.1 unix parallel environment (same functionality)...

I have used a sequence routine stage to call a routine which will create a list of jobs in which a particular table is used. The TableName variable can be replaced with FileName and will create a list a list of jobs in which a particular file is used. *------Searching for all jobs with vTableName --...

IBM RESPONSE: Re: ISSUE: How do we execute/switch the Multi Client Manager within a script so we can run our backups without manual intervention!!

You can't. The Multi-Client Manger is not designed to support command mode switching.

IBM RESPONSE: Finally got the syntax down for what you are attempting to do. The first thing is that the dscmdexport.exe will not work in a batch file exporting from both DataStage 7.5.2 and DataStage V8.0.1. You need to run the Multi-Client Manager to set which version you are planing to export, an...

We were unable to add a project to IIS 8.0.1 after adding two projects previously. Initially we cleaned up the file system directories and files but this didn't work. We then had the Oracle DBA increase the Oracle 10i repository by 300% to 4gig and this worked. We had not sized the repository adequa...

IBM Case 701082 has been opened to address this issue. Ray: Have you run out of disk space on the file system where you are trying to install this project? The file system is shared with DataStage 7.5.2. The project that was at issue was when we tried to add a project to IIS 8.0.1. We checked the fi...

IBM Case 701084 has been opened to address this issue.

The following error was incurred when adding a new project in IIS 8.0.1 DataStage Administrator.

DSR.ADMIN: Error creating DR elements. Error was -1.
Error Adding Project.

Note: Two projects had been previously added successfully.

As far as i can see the DSHOME environment variable has been set up correctly. DataStage 7.5.2 /dstage/Ascential/DataStage/DSEngine/dsenv DSHOME=/dstage/Ascential/DataStage/DSEngine; export DSHOME LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSCompo...

Using the single project name doesn't find the project so i was trying to figure out how to point to the DataStage 7.5.2 projects versus the IIS 8.0.1 projects. It's interesting that our script pulls the dsparams files for the requested project but the dscmdexport can't find the project. Note: Our b...

How do we backup DataStage 7.5.2 and IIS 8.0.1 installed on the same server We have DataStage 7.5.2 and IIS 8.0.1 Upgrade installed on the same server. Issue: How does the dscmdexport command find the project with two project directories? The IIS 8.0.1 projects are in the /u01/dsprojsv801 directory....

IBM CASE 700511 The entry in the uvodbc.config file should not be altered -- here is a copy of that from uvodbc.config: "localuv" as defined below - please do not alter this entry! Therefore, the entry should remain as follows: [ODBC DATA SOURCES] <localuv> DBMSTYPE = UNIVERSE network = TC...

Here is the error message in the &PH& error logs that i get when validating or running DataStage 7.5.2 or IIS 8.0.1 jobs (DB2/Oracle/Sybase/Teradata):
DataStage/SQL: Failed to establish internal local connection.

The release notes doc has the following excerpt. The release notes are in */is-ia-suite/InfoServerReleaseNotes.html During installation the Oracle operator library is incorrectly referenced with a symbolic link containing a .so instead of a .o extension. This issue can be resolved by running the ins...

We have just installed IIS 8.0.1 (update): We are getting the following error using the Oracle Enterprise Stage: IIS 8.0.1 Error executing View Data command: ##e iis-dsee-tosh-00205 08:10:00(008) <MAIN_PROGRAM> path SEARCH FAILURE: PATH search failure: >##E IIS-DSEE-TFOG-00006 08:07:53(014) <main_pr...