DSXchange

Trying to install InfoSphere 8.1 on AIX and the installer is complaining: Error: Space available at /My_work is 124MB where as required disk space is 1924MB. Error: Space available at /dstage is 21MB where as required disk space is 9126MB. Well, /dstage was never specified anywhere and in fact, onl...

Trying to install InfoSphere 8.1 on AIX and the installer is complaining: Error: Space available at /My_work is 124MB where as required disk space is 1924MB. Error: Space available at /dstage is 21MB where as required disk space is 9126MB. Well, /dstage was never specified anywhere and in fact, only...

Thanks!

We are purchasing QualityStage. Any recommendations as whether this is fuel for a DataStage 8.1 upgrade or if we should stick with DS 7.5.2. I don't have QS experience. I know that is part of the install with 8.1 and that is has been made more native. Does this mean it is part of the DS engine or do...

Hi all, my job got aborted and the log view is given below, .Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed. SQLSTATE=S1000, DBMS.CODE=1555 [DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with n...

Thanks, How is the Merge command supposed to run. Will it be run manually by DBA to load the table. Thanks Define manually? For instance, you could write your own shell script and use the external source stage to invoke the MERGE command and capture the return code and feed the return code back to ...

I have split up my inserts and updates into 2 jobs My Job design is as below OracleEnterprise1----->Trnsfr------->Trnsfr1------->Oracle Enterprise2 In the stage OracleEnterprise1 i extract data from a oracle table, In Trnsfr I do Trim 3 or 4 columns and add a couple of new columns then map them to ...

Offshored2002 wrote:Thanks, I feared that was the answer. Not terribly useful to have to go get event ids from Director right now.

I had this feature rolled forward into 7.5.3. Can you upgrade to version 7.5.3?

I am trying to trap the log details from a parallel job. When I issue the command dsjob -logdetail <project> <job_name> The following comes back: Invalid arguments: dsjob -logdetail [-useid] <project> <job|jobid> <first event id> [<last event id>] Status code = -9999 DSJE_DSJOB_ERROR Going into dir...

Hi, we have a job where we pull data from a oracle table and then we have one stage which inserts data without clearing and another OCI to update existing data. But the data is very huge around 30 million records.the record length is around 40 characters,right now i have array size set to 5000 and ...

Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this i...

Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this i...

After much work and patch investigation on my part, I was able to find out that IBM backed out some changes from our Template for dsjob. I was able to build some commands to fix the Template and the new Projects. To fix the Template: PDIR="/ascsoft/DS752/P002_COMPOUND/patch_meijer" ## Fix ...

I have got an update for this issue... The prior column is a varchar2(4000) column .This column contains a "\n" characters in it . When i tried viewing data ,it shows data partially .. The data after the varchar2(4000) column is not shown... Any clue of how to remove the "\n" ch...

nsm wrote:All,

I was doing an export and my Client went to no response mode for long time. So I closed the client and then tried to login again , Its not letting me in where as I can login into my Director Okay. Was not sure how to resolve the issue.

Thanks
nsm.

Did you try a reboot of your workstation?