DSXchange

A colleague of mine had a problem where some times rows would be returned and at other times 0 rows would be returned when there should have been. I turned out to be a compatibility problems with the DataStage sap plugin and the patch level of the SAP version they were running. Informix came out wit...

Hi Craig, I think it is something specific to SAP stage. The customer told me that they are trying to extract data from SAP, but they get no rows returned. The problem is that there are definitely rows that should be returned and that is where the trace files come in. So, I dont think using the norm...

Were running into intermittent failures when running dsjob -jobinfo on UNIX. The error message is: ERROR: Failed to open project Status code = 39202 Has anyone come across this before ? regards, Peter NOTICE This e-mail and any attachments are confidential and may contain copyright material of Macqu...

Unless you mean something specific to the SAP stage, you can always set trace on for your jobs thru the Administrator. Switch from the General to the Projects tab, select the project you need to work in and click the Properties button. You should see several (six?) tabs, one of which is Tracing. You...

Hi Guys,

Somebody told me a while ago that it was possible to create trace when using the SAP stage that can be used to debug problems. Does anybody have an idea how to enable this?

Thanks,
Tom

This is a topic for an orphaned message.

As long as you are root user, using ds.rc start and ds.rc stop should work. I added the new startup/shutdown interfaces ( uv -admin -start, uv -admin -stop) to provide that the non-root administrator dsadm also have the ability to start/stop the DS server (dsadm CANNOT normally run ds.rc start succe...

This is a topic for an orphaned message.

Hi all I had a weird problem today... UNIX server, hosting Datastage 5.1 We had to shut the server down (datastage server) this morning and bring it up again. Usually we use these commands: /etc/ds.rc stop /etc/ds.rc start This morning we brought it down with /etc/ds.rc stop and it was succesful. Th...

Hi Alexandre... There are many ways to reach DB2 sources on the mainframe, some of which depend on the platform you are on and the configuration of other software available to you... IBM has an ODBC offering called Client Access that works great from NT, and if DB2 is everywhere at your site, IBMs D...

Hi, All Explain the situation please. Ascential Web site has a picture where is described the DataStage functionality (not DS XE/390). This picture displays the DB2 on mainframe as one possible source. Does the standard functionality of DS allows to read / write data from/to DB2 on mainframe or I ne...

Hi Guys,

Im busy at a customer site, that uses Informix as a data source. Now, I know that Datastage does not support blob/smartblob data types, but how about node data types and html data sitting in the database?

Thanks,
Tom.

Thanks a lot Ernie, Len, Galemmo, also from my collegue Riccardo. You was really helpfull. Best regards Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: To: Sent: Thursday, February 28, 2002 7:31 PM Subject: RE: named pipe...

Hi Kim, Thanks for the info. I rebuilt the indexes but still no sign of my job. The DS_JOBS file looks okay as I can cout all the jobs. I also did the project cleanup but with no luck. I guess for now I will have to revert back to backup... Thanks, YN --- Kim Duke wrote: > YN > > Most likely you cor...

YN Most likely you corrupted an index. If you telnet into your box you can rebuild your indexes with the DS.TOOLS menu. The trick is you have to have exclusive access to DS_JOBS to rebuild the index. If you run LIST.INDEX DS_JOBS ALL then you can see all the indexes on that file. You should do this ...