Archive | DataStage RSS feed for this section

DataStage Server Job large XML file

11 Apr

To an XML file in a Server Job using an “XML Input Stage” you can use a “Sequential File” or “Folder” to send two columns – the first being the filename the second being the contents of the file.
– To do this you would send the option in the “XML Input Stage” as “XML file”

This is kind of hacky – it reads the whole XML file into the second column. I am running a VM and found that this wouldn’t work for XML files > 50meg.

If the file is too big you can get around it by using the “URL/File Path” option in the “XML Input Stage”. In this case the “Sequential File” or “Folder” must send the filename of the file to the “XML Input Stage”. This seems to allow you to use bigger files.

Play around with the “Convert CRLF” and other options in the “Sequential File”/”Folder” to get what you want.


DataStage executed job return value

4 Apr

Example of how to run a job from “Job Control” in DataStage and set a status (or return value) from an executed job

      ErrCode = DSWaitForJob(hJob1)
      Status = DSGetJobInfo(hJob1, DSJ.JOBSTATUS)
      If Status = DSJS.RUNFAILED Or Status = DSJS.CRASHED Or Status = DSJ.ERRFATAL Then
         * Fatal Error - No Return
         Call DSLogInfo("Job Failed!!!!: MITS_Cons_FTP", "JobControl")
         RetVal = 'Failed: Initial MITS_Cons_FTP failed'
         GO TO THEEND:

  Call DSLogInfo("At the end, retval is " : RetVal,"JobControl")
  Call DSSetUserStatus("STATUS: " : RetVal)

unlock datastage jobs

28 Feb

In IIS v8, you’ll need to login to the Web Console “http://:9080” go to ‘Administration’ -> ‘Sessions’ and disconnect the offending session!!!!!!!!!!!

Found this on a forum:

1. Login to DataStage Administrator as an administrative user.
2. Go to the Command Prompt for that Project.
3. Look at the locks by executing:


4. The last column is the item id. Look for item id’s like:


This is the record you will want to unlock. Now you can note the inode or user no, whichever uniquely identifies the record.

5. The unlock command is not available by default in the projects. To create an entry to use unlock execute the following two commands:


Note: This only needs to be done the first time in each project.

6. To unlock by either INODE or User No use the commands:

UNLOCK INODE inodenumber ALL
UNLOCK USER usernumber ALL

DataStage Error:

18 Feb

“Abnormal termination of stage xxx detected”

If you get this on a Transfomer stage that takes in hashfile lookup’s, try remaking the hash files

DSR.ADMIN: Failed to add user to UV_USERS file

20 Aug

I got this when i tried to a login to DataStage Designer with the server running on Linux but the OS user on the linux box not being in the same group as the DataStage user (which runs datastage).

In this case I had to change the primary group of the user in /etc/passwd to be the same as the group that owned the files in /opt/IBM/InformationServer.

Powered by ScribeFire.

ADMU7711E: Unexpected exception associated with WASService.exe:

19 Aug

Problem with starting the WAS server:

ADMU7711E: Unexpected exception associated with WASService.exe:

ADMU7711E: Unexpected exception associated with WASService.exe

Powered by ScribeFire.

Find WAS server that IBM Information Server uses

19 Aug

IBM Information Server uses a Websphere Application Server. If you have multiple WAS servers installed, to find the one that IIS is using you can look in:


This should contain the USER_INSTALL_ROOT, e.g.:
set USER_INSTALL_ROOT=C:\IBM\WebSphere\AppServer\profiles\default

Powered by ScribeFire.