DSXchange

Looking for recommendations for the most reliable way to convert dates from Unidata to Oracle 8i. Presently in the Unidata stage we define the type as "date" and in the Oracle stage as "Timestamp 19". The generated SQL then converts the timestamp to date type with a to_date funct...

Thanks Craig. Are you saying that the Ora9i stage should work with 10g and possibly 11g or that there is a new ora10g out which I don't know about?

We are about to move from Oracle 9i to 11g. Does anyone know whether there are Oracle stages / plugins for versions higher than 9?

Thanks Ray - yes, I am running as administrator, but no good return. thanks.

Does anyone know of good documentation of considerations for setting values in uvconfig? especially for MFILES, T30FILE, LOGBLSZ, TXMEM, OPTMEM FLTABSZ, GLTABSZ, RLTABSZ AND MAXRLOCK.

Worst case you could run the job with a warning limit of 1, it seems to me. Thanks Craig, Your suggestion made me realize that the same thing could be done in Job Control with RUNWARN: Status = DSGetJobInfo(hJob31, DSJ.JOBSTATUS) If Status = DSJS.RUNFAILED Or Status = DSJS.CRASHED Or Status = DSJS....

How can the failure of an SQL call from an ODBC stage be returned as a FATAL rather than WARNING event? We are making Oracle procedure calls from the ODBC stage SQL dialog box in the form {call oracle_schema_and_procedure_name} Failure of the procedure returns a warning event and the Datastage serve...

smat -d running from the windows command prompt always responds "No type 30 files active." when we know that more than 50 Datastage jobs are running. Other parameters work OK, e.g. smat -t lists all of the uvconfig values. IBM support has, so far, not been able to identify the problem. Hav...

ArndW wrote:I'm not sure what could be the cause here, since the OPEN for a hashed file shouldn't time out. The "-99" is not a valid return code for the OPEN command so I don't know why the open would fail.

Arnd, the opens which are failing are on Sequential files, not hashed.

chulett wrote:D'oh, I meant T30FILES and as Arnd mentions, problems with it being too low are typically pointed out directly in any error message.

I have no "T30FILES" setting in uvconfig, just T30FILE (=400).

When I said I liked Arnd's signature file I thought I was responding to you.

Yes, you can raise MFILES without fear in this case. The RT_STATUSnnn files are dynamic files (Type 30) and thus affected by the T30FILE parameter, and if you had reached this limit the error message would have been clear. Or it should be, what is your T30FILE setting? Is this problem always for on...

chulett wrote:What's your MFILES setting in the uvconfig file?

MFILES is set at 150. Do you think it is safe to up it 10% without doing the research on kernel per process limit or application named pipes?

When load is heavy on our server (DS 7.5.1 on Windows 2003 server) jobs which write to text files on the DS server abort with message like: _____________________________________________________ Batch::AddressIncr..JobControl (fatal error from DSRunJob): Job control fatal error (-99) (DSGetJobInfo) F...

We have found a crazy solution to the abnormal termination of stage message when nothing else works. In the transformer change all of the DATE formats to VARCHAR2 on the Oracle target side. Then change the SQL to USER DEFINED SQL and use the to_date function to convert the varchar to date format. Fo...