DSXchange

By searching the forum, i found that many people suggest that increasing these parameters will not help much.

Anyways, we raised this to our admin. I will post their solution once i hear from them.

Did you try refreshing the director or closing or reopening it?

Hi throbinson,

Our default configuration settings(uvconfig) are as below:
GLTABSZ =120
RLTABSZ =220
MAXRLOCK =219

We had 80 to 90 jobs started at the same time (04:00 AM) out of which 32 failed. Out of these jobs few were running in multiple instances.

Hello Barbara, Are you trying to display in the target as '0.00' (varchar datatype)? If yes did you try this: Field(DecimalToString(STAGE_VARIABLE_NAME_HERE, 'fix_zero, suppress_zero'), '.', 1) : '.' : Left(Field(DecimalToString(STAGE_VARIABLE_NAME_HERE, 'fix_zero'), '.', 2) : Str('0', 2) , 2) Let u...

Hello Barbara, Are you trying to display in the target as '0.00' (varchar datatype)? If yes did you try this: Field(DecimalToString(STAGE_VARIABLE_NAME_HERE, 'fix_zero, suppress_zero'), '.', 1) : '.' : Left(Field(DecimalToString(STAGE_VARIABLE_NAME_HERE, 'fix_zero'), '.', 2) : Str('0', 2) , 2) Let u...

mch_suresh,

Please don't post your inverview questions here!!
If you really need them, then there is a search facility among the various options avaliable on the front page itself..I suggest you better go with that.

SEARCH

You will get a looooot of environmental variables.
Esle, look into DataStage reference manuals.

Peek Stage

Just peep into the directors log. By default, if the peek record output mode is set to = JobLog', all its related log information will start with your peek stage's given name.

If the peek record output mode is set to = JobLog, then it will write to second output link of this stage.

Thank you ArndW,

We have reported this to out UNIX server admin.

Share your credit card details!!
I can give you the basic DataStage training. :D :D
Take it easy....

Did you try out this before posting:

Did you try out this before posting:

If you have Unions split it into multiple stages. And if there are Joins in the Sql, use the stages as required.

If you have Unions split it into multiple stages. And if there are Joins in the Sql, use the stages as required.

just4geeks,

Did you import the Oracle metadata from the table definitions or edited it manually?

The 'Only' reason for your case is that your datatypes from the source isn't matching with the metadata you have imported/edited.

As Ray said check them first.