DSXchange

Hi,

Try to Use the Build In Routine "DataTypePicS9" To convert the data type in EBCDIC into an integer.

-Chandru

Hi Sam,

The Best way to accomplish Header and Trailer in Seq File is to Create Header,Trailer and Detail record in a Three Different Seq file and Concatenate all the three Seq file into One.In which you have Header,Detail and Trailer Record.

-Chandru

Hi,

Try to Log into UV shell Instead of Datastage Administrator.

$ cd `cat /.dshome`
$ pwd
/opt/Ascential/DataStage/DSEngine
$ . ./dsenv
$ bin/uvsh
Once Logged in:
>LOGTO <yourprojectname>

you can Issue the Admin Commands in UV shell.

Hope this Helps.

-Chandru

Hi Srini,

Can you explain us your Job Design for both the Jobs.

As I guess that the error thrown is towards the Buffer.Also Can you check the Dump Score and let us know the OutCome of it.

-Chandru,
"You see things and Say Why? I dream of Things and Say Why Not?"-Bernaud Shaw

Hi Kduke,
Thanks for your reply.
I mean if I change the NOFILES in Unix.Will I need to change any other kernel parameter in Unix level as becoz ,we run other application ,so I doent want to Impact it.
Thanks
-Chandru

Hi Kduke, Thanks for your info.One more thing to add.If I increase the NOFILES in Sunsolaris 2.8 will there be any impact in OS(like kernel parameter to be tunned or changed). Following is my Config $ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 c...

Hi, We also tried to use but could not accomplish in the before Sql. So we used Before routine to do the truncation paste following code in job before routine and substitute according to yours Eg: db2 "connect to <databasename>";db2 "export to '<filepath>' of ixf select * from <tablen...

Hi, First you need to to Install Db2 Connect(Which Communicates to AS400).After that you have to Catalog your Database Following is the Syntax to do it: 1.CATALOG TCPIP NODE <yournodename> REMOTE <IpaddressofAS400> SERVER <portnumberofserver> 2.CATALOG DB <databasename> AS <databasealiasname> AT NOD...

Hi, I agree to use the Bulk Load Utility to populate data to db2 tables.But One Concern in using it is that it monopolize the Tablespace.So take causion in using it preferrably test it (Becoz say the load fails inbetween populating data then the tablespace state will be in quiesce mode you need to u...

Thanks Ray,
I found that the problem is in the RowBufferring ,Once I disable it i could get the Last record,Ray did you come with this problem anytime regarding rowbuffering

-Chandru

Hi Ken, We have issue in Sequential File stage,I try to write a 500000 record from the source to target both sequenctial file doing two hash file lookup(No constrains),The issue is that,the last record is missing in the target which is present in the source((In Unix i use the tail command to view th...

Hi, we are using Metastage version 6r4,And i tried to Import Business Object v6,With metabroker BusinessObjectv5,It works fine and i connected the Objects and i Analyzed it works fine,But when i subcribe to Business Object v6 the table's are imported but not the joins,i could find the Business Name ...