DSXchange

Thanks Ray.

but why it is convert into Decimal. I hope as per ORACLE NUMBER (10) stored 10 digit number.

Thanks
Man

Hi I am trying to import metadata from ORACLE 11g to Datastage via Connector import Wizard . In oracle column defined as NUMBER (10) that means it equal to Datastage Integer. But when I import it is showing Decimal 10 instead of Integer. NUMBER(10) . Is this anything I have to change in setting ? Th...

Sure

I will check it. I have imported this job from 8.1 into 8.7.

We have applied 8.7 FP1 too.


Thanks
Man

And also I have noticed I am seeing lot of places libjvm.a file are present find / -name libjvm.a -print 2>/dev/null /apps/IBM/WebSphere/AppServer/java/jre/lib/ppc64/classic/libjvm.a /apps/IBM/WebSphere/AppServer/java/jre/lib/ppc64/j9vm/libjvm.a /opt/IBM/InformationServer/ASBNode/apps/jre/lib/ppc64/...

Hi I am getting following error while run time. The same job running fine in Datastage 8.1 . I have moved this jobs into Datastage 8.7 //------error WS_Call_Tfm: TJClient::initialize: unable to create Java Virtual Machine; classpath = /opt/IBM/InformationServer/Server/DSEngine/java/lib/wsclient.jar ...

Thanks

we are not using tnsname.ora using ldap.ora . Is this any issue with user?


Thanks
Man

Thanks.

But we are not using tnsnames.ora file we are using ldap.

Thanks
Man

Hi we have migrated jobs from 8.1 to 8.7 and using ORACLE 11G . we have DEV,QA & PROD environments. I can able to use ORACLE connector stage on QA environment and following path set same way on all the 3 (DEV,QA & PROD) servers. ORACLE_HOME=/app/oracle/product/11.2.0/client_1 TNS_ADMIN=/app/...

I am thinking about that client issue or else we need to apply 8.7 FP1 Server and client too.

Thanks lot. I have fixed this issue. I have found the issue with filesystem and /GB Block size. df -g /opt/IBM/IIS/Staging Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/stg 24.00 3.12 88% 5329 1% /opt/IBM/IIS/Staging I have asked UNIX Admin to increase GB blocks from 24.00 to 400.00 G...

Thanks lot. I have fixed this issue. I have found the issue with filesystem and /GB Block size. df -g /opt/IBM/IIS/Staging Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/stg 24.00 3.12 88% 5329 1% /opt/IBM/IIS/Staging I have asked UNIX Admin to increase GB blocks from 24.00 to 400.00 G...

Not tested that one.

May be I will test with some sample job to write in target dir with 2GB .

But I would like know in where OS level we will limit this.

Thanks
Man

F_1 is : Sequential_File Stage. reading datadeom FileSet - > Transformer -> F_1 Sequential_File Stage I have checked with ulimit -a. Executed command: ulimit -a *** Output from command was: *** time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 4194304 memory(kbytes)...

Hi we are in the process of convert jobs from Datastage 8.1 to Dadastage 8.7. I am getting following error write into Sequential File stage. F_1,0: Export failed. F_1,0: Output file full F_1,0: Input 0 consumed 2995232 records. F_1,0: Fatal Error: No file descriptor was supplied. Trans_List,0: Fatal...

is there anything I have to increase limit to 2 GB?

May be the issue file system 2GB limit.

Thanks
Man