DSXchange

HOW did you create the hashed file? Can you go to the admin tool or UVSH and do a "LIST DICT {HashedFileName}"

Your block is 1.6Mb and you set the maximum block size to 1Mb and are surprised that the block doesn't fit?

How did you create the hashed file - unless you created it within DataStage and used the same key columns in the same order your lookup will most likely not work.

You've got a converstion somewhere in your stream. Add "APT_DUMP_SCORE" to your job parameters, run it with the value set to "True" and see if you can find references to this column where it might be being redefined.

Do you have a single key column or multiple keys? Please give one example of a key that fails. Note that keys "HELLO" and "HELLO " might look the same but are distinct.

Your transform stage input column HEUR_RELV_SOLD_PP is defined as Char(8), perhaps you inadvertantly redefined it in the sort or join stage. Without an explicit conversion, i.e. StringToTime(), DataStage won't convert it back.

Do you really expect someone to give you a valid guesstimate without knowing a single thing about your project? Does it have 1 job in one project, or 8000 jobs split over 6 projects? Is it a 24x7 high availability production system with complete hot-standby of production, integration test, developme...

Run the job to reproduce the error. Immediately go to UNIX and do an "ls -al" on your dataset descriptor file ("/dstage1/store/Data_frm_OAGCRD.txt") and then do a 'orchadmin ll /dstage1/store/Data_frm_OAGCRD.txt' as well. Does the data file in the error message, the one in /node1...

I use the syntax

Sabarinirmal, this is an all-volunteer site, and if you don't wish to use search but expect someone to do this work for you, particularly for a problem that is 'critical' to you then I feel your expectations of this site are incorrect. Just click on the Search word here or on Search at the top of ev...

The link to IBM 8.0 Release Notes makes a good start, since the answer to the question is rather long and involved.

pradkumar wrote:...I tried with by using the decimal to string fucntion but still not getting the desired output...

Since we don't know what your output was, or what your desired output was there is little that anyone here at DSXChange can do to help until you explain the issue.

Rename the .isx file to .zip and standard uncompression programs will expand it.

istool outputs in dsx format and compresses the data.

Are all of these open connections to DB2 from DataStage and from this run? You certainly shouldn't have that many open from one DataStage run, as you've already stated with 1-node and 15 DB2 stages that is how many connections you should have. Is your Db2 partitioned?