DSXchange

Hi All, the problem with that job was once i run the job it is not generating any log . basically it took 3 minutes to complete. but even after 120 minutes also no job log and job still in running stage. once i click to STOP then only the job start generating the log and will abort. this is what i m...

Hi ,

Are you working on the test server.
if so then do one thing if u have the backup of that job. then delete the existing and import the job from the previous backup from the .dsx file.
in my case this export and import had resolve the issue.

HI All, Can anyone confirm why Change capture stage is not working in the Datastage EE 7.5.3 initially the same job was working fine at version 7.5.1.A I tried a few work around 1. by changing the following enviornment variable $APT_DISABLE_COMBINATION = TRUE 2. Increase the number of node by 1 to t...

The following piece of code need to be change from

dscapiop dscapiop 1

to

dscapiop @dscapiop 1

in the operator.apt file to make the DRS stage in a position to access the ODBC connection.

the following are the files which need the treatment to make the DRS stage operational.

drsenu.so
drsjpn.so
drsodbc.so
drs.so
libdsplugin.so
liborpheus.so

After adding this files the DRS stage even at Target Stage is Working.

Hi , Initially the job logic was DRS at the target side and was unable to execute the before and after SQL. Since it was a staging table and the only objective was to truncate / delete as per the business area. now i use it in the source end and use the logic. while reading the data from the table a...

My apology for this mistake. any way to bring it back to the actual forum.

Datastage version : 7.5.3

Parallel job

ODBC information is also added into uvodbc.config

HI , i am trying to delete a few data from a table where i have the delete permission. the job is working fine. but is not deleting the data at the database end. when i am running the same query in the database i am able to delete the flow of the job is: Sequential read - > copy --> Odbc ( delete fr...

You have no columns defined on the input link. But you have one parameter marker in the SQL. This is not a correct combination, which is what the error message is telling you. ... Hi Ray, the same piece of code was working fine in the version 7.5.1a but not in 7.5.3 i had contact to IBM . they had ...

As earlier Ray had told, check where is the location for the scratch space. it will be mention in the Configuration File. now check that location lies in which file system and check the free space. can you check how many cpu are there in your respective server let say 6 CPU are there then mention 3 ...

the stage used is a DRS stage

the SQL used in that Stage is as followed:

INSERT INTO UKCUSTOM_CUSTOM_DRIVERS (CUSTOMID) VALUES (?)


Before sQL Statement:

DELETE FROM UKCUSTOM_CUSTOM_DRIVERS WHERE CUSTOMID <> '';

there is no After command used.

Hi Ray, I run it with the Enviornment variable I got the following error: drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Failure during execution of operator logic. drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Fatal Error: Fatal: The 0 column(s) defined on this link do not match the 0 column result set generated by the SQL...

Could you please let me know HOw to disable the operator combination.

I guess at the base level DRS stage is using the Generic ODBc to connect to the target database.
SO it may be a problem with ODBC connection.

This job was very well working in 7.5.1.A but failed in 7.5.3.

The user must be a member of the dstage group

or take a member user id who are able to execute successfully
see which all group he had been assigned in that server. Assigned the group it him. it will work.