DSXchange

Please provide the error message that follows.

Also what version of DB2 are you on?

Have you verified that the parameters passed from the sequencer to the job when run are all correct?

Do you know what the practical maximum size of the xml that you will be reading is ?

What type and length are the key fields?

What version of AIX are you using (including fixpack)?

What type of SAN are the files on?

What is the size of your swap space on UNIX?

When using DB2 define the datetime variable as varchar 26

Then use the format 00:00:00.00000 for the time portion of the datetime string.

If you use char(10) for dates and varchar(26) for timestamps for both reading and writing to DB2 through the plug in it works well.

This works with versions up to 6. I haven't yet tested it in version 7.

What version of DB2 are you using?

What version of db2 are you connecting to and what version of the db2 connectivity software are you using?

db2 version 8 completely changed the API.

Does the userid you are running the jobs with have any file system limits. I have see some installations where the default amount of disk space a user can use is limited to 1 GB. May be worth checking.

If the issue is time out, you can modify the rb_tmu code as follows: rsh 10.7.145.2 -l redbrick rb_tmu -i nrows %2 where you set nrows to the number of rows after which the loader will write an information message back to the client. Red Brick Manual says: "Directs the TMU to print a progress m...

At one time there was a limit in the Sybase API of an 8K sql statement.

What does Sybase support say?

to field in seq file use

(linkname.seq_field_name + 1 - 1)

this will convert it to 0 which will then match with the lookup

Define the timestamp for DB2 as Varchar(26) when you read it from DB2.

Had a very similar problem before. What you need to do is see how the disk drives / LUN's are actually mapped to the RAID groups. You may be trying to separate IO and in reality be exasperating it. If Disk 1, Disk 2, Disk 3 and Disk4 are used in LUN1 and LUN2 and LUN3, then you should make all of th...

What version of DB2 are you using, as well as what platform is it on?

As well, are you using ODBC or DB2 stage to connect to database?