DSXchange

Hi there,

I may had been heared that Datastage does not have a server edition with v8.x, only enterprise (parallel) edition for 8.x. Is this the case? Some posts here state a server edition with v8.x. This confuses me.

Thanks,

Hi there, Even in file .odbc.ini defines a lot of ODBC datasources, and they work well in the ETL jobs, when try to import table defintion from ODBC datasource, the following is showed with Import Meta Data (ODBC) Empty DSN: list returned from host svrxxx How to solve the issue? You even can not typ...

Hi,

Currently jobs keep failed at "SQLFetch: Error retrieving results from server." and more and more jobs have the problem.

What's the problem: Datastage side or DB2 side? How is the problem fixed?

Thanks,

[quote="chulett"]You can't. I have no idea why it works that way or what "Stopped/Restartable" is really supposed to mean when it [i]cannot[/i] be restarted from the point of failure. :roll:[/quote] That's really bad. It destroys the great checkpoint feature completely if this de...

[quote="ray.wurlod"]Who stopped it? "Stopped" means stopped by user intervention. ...[/quote]

It's stopped by another job having trouble. These jobs are running in parallel.

Hi there, When a sequence is abended prematurely, it has status "Aborted/Restartable". When it's restarted, it starts from the failed point or the checkpoint. When a sequence is stopped, it logged an item as below: Item #: 176 Event ID: 175 Timestamp: 2009-10-08 16:20:55 Type: Info User Na...

Thanks for all your responses. Now I know what's the problem. The key word here is "Allow multiple Instance" Job. It is the attach command. Only when this command succeeds, other operations can be followed. If it's executed once from a regular sequence job with a job activity, it can be at...

Hi There, LoadRunStats is an "Allow Multiple Instance" job. When the following statement is executed in Job Control tab of a job properties LdJobHandle=DSAttachJob("LoadRunStats.AutoMeter", DSJ.ERRWARN) The error below is showed. How to fix the problem? Thanks in advance, EEROR M...

Thanks Craig.

What happens for those do not support returning multiple look up results when a search yields more than one records? Do they just pick up one randomly and return to users?

Thanks,

Hi there, Multiple look up results means one searching returns more than one results if more than one records meet the search criteria. We all know hash file does not support multiple look up results. I know only ODBC data source supports multiple look up results. Is there any other database source ...

Thanks, Chulett.

That means if the job log is too big, such as hundred thousand entries, then it will hurt the job performance. Is this right?

Another question, are all UV tables stored as hash files?

Thanks,

Hi there,

How is the job log stored in Datastage server? Is it stored in a hash file?

Thanks,

Thanks, I found where is to configure. Only ODBC support multi results lookup.

Hello every one,

If a DB2 or ODBC Reference lookup results in multiple results, can all of them be returned? But not just
XfAddress..Email_E_Trns: Reference lookup generated 2 rows. Only the last row was used.

Thanks,

When an environment variable with $PROJDEF as default value is used in a job as a job parameter, I hope the true value for the parameter is showed as the job is being launched, instead of $PROJDEF, like it is now.