DSXchange

Based on your other post I sincerely doubt you should be using that particular stage.

suneelchallagali wrote:one more thing does db2z/os is only to retrive or load data from db2 database on main frames only or db2 database on other environment(windows or unix).

The name of the stage is a big clue to the answer. Yes, right, only for DB2 on Z/OS.

Looks like you and Sree should talk.

viewtopic.php?t=131620

I've never touched DB2 in my life but I seem to remember from reading here that you need to 'bind' any new DB2 database you want to access. Have you done that?

There are plenty of Oracle date functions, you could write a looping function to compute this for you and select it as data from your source table. Day numbers of 1 and 7 indicate a weekend day, from what I recall.

Recompiling a job 'resets' it, otherwise it retains the value last put there until another takes its place. And you didn't really answer or respond to any of my questions.

So... are you saying that you have 8.1 installed but it's not working because it can't communicate with your DB2 XMETA install? I didn't think that was possible and that it checked connectivity during that process.

It couldn't hurt to Unschedule the job and then Add to Schedule again. If there's any doubt about what it did, do a "crontab -l" from the command line as the scheduling user and post it here.

What database?

Was this a recurring schedule or a one-time one? The former uses 'cron' while the latter uses 'at'. Can you post the appropriate entry from the scheduler itself, cron or at? Meaning nothing from Director but rather from your O/S.

There's really no architectural differences between 8.0.1 and 8.1, what you're really asking about are the differences between the 8.x release and every release that came before it. The 8.x documentation includes an Introduction pdf that "provides a scenario-based overview of IBM Information Se...

What O/S? What does "doesn't show up correctly in the Director" mean, what exactly are you seeing?

It may not be documented all that well, it works in more than just the DRS stage from what I recall.

'Not able to' is a little nebulous, what exactly happened? Have you tried using a lower client version on the DataStage server? For example, a 10g client to connect to the 11g database?