DSXchange

hI

How to create a project from commnad line?
We need this info, because we have a sudo access to our id, from which we can change to root.. But we dont have passwd of dsadm.

Thanks
Sai

Hi Chullett

It is working fine, via the root told by you.

i.e Plug-in Metadata via OCI stage route.

Why the other way is not working?, any idea

Thanks
Sai

When I try to import metadata from the oracle server through DataStage import metadata option, I am getting the following error: DSR.MetaGeta(GET.PROCS)(SQLConnect('comm_sp1','cmmstg')): BCI Error: SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][unixODBC][Driver Manager]Data source name not foun...

The job which loads from Oracle stage to direct sequential file stage is also aborted at around 13 million records.


Thanks
Sai

The main hindrance to the experimentation now is...

Each run is taking around 2 hours to give the result... So, Advice is taken ...but I will see whether that time is available for now or not.. as I am in production, I have to load ...without delay...

Thanks
Sai

Hi Transaction size is 0, Array size is 30000. We have put nologging in the target table, to which we need to load. So , there is no rollback segment will be generated. Even, We have tried, replacing target OCI stage with a sequential file stage and rant the job. but still we are getting similar pro...

Hi

a. The job with 1=2 condition, is aborted at in the middle at around 13 million records. (Overall number of records: 28 million)

b. The job which directly loads from OCI stage to OCI Stage, also aborted.
(Without transformer)

Any other solutions?

Thanks
Sai

Hi ArndW

FYI: The job is not aborting at the same row number.

I will implement 1=2 and the other options you provided.

One thing I want to tell you is It is taking around 2 hours to run this job and then it is aborting... So, I need to wait for 2 hours, if I do any experimentation..

Thanks
Sai

More info about the comparison of old server and new server: 1. In our new server NLS is installed, old server no NLS installation 2. I have compared uvconfig files in the two servers, I found the following difference: < GLTABSZ 130 < GLTABSIZE 130 --- > GLTABSZ 120 214,215c213 < RLTABSZ 130 < RLTAB...

I have searched the forum on this... But could not resolve my issue... My I tried running my job for 1 lack records, it worked fine. When I try to run 28 million records, I am getting this problem at around 12 -13 million records. I have removed the target DB stage, and replaced with sequential file...

I am getting the follwoing message in the next run From previous run DataStage Job 413 Phantom 3117 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program JOB.1133835455.DT.1454325365.TRANS1 at address 2fc. CRITICAL ERROR! Notify the sys...

Hi When I run a job which selects records from an oracle table and inserts to oracle table, I am getting the following warning, and then job is aborting. Abnormal termination of stage push_user_table_10pct_m..xfm_stage detected The design of the job is as follows: ORACLE Stage -> Transformer ->Oracl...

Thanks ArndW and Chullet

It is working fine now....

Thanks a lot...

Sai

I think the problem is there in

LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/$
jre/lib/i386:$LD_LIBRARY_PATH$

The above post is after executing ":set list" in vi editor.