DSXchange

DB2 Docs SQL0311N The length of string host variable number var-number is negative or greater than the maximum. Explanation: When evaluated, the length specification for the string host variable, whose entry in the SQLDA is indicated by <var-number> (based at 1), was negative or greater than the ma...

ml wrote: you need to run . ./dsenv before ./bind20

Leonie, why don't you source the dsenv file as ml suggested ...

trainee9999 wrote: VC++ compiler.

What do you mean by (VC++)? is this the same as Visual Studio .NET ?

Don't forget $ORACLE_HOME/lib

Don't forget that the Windows user account must have the correct windows file permissions on the DataStage server install directories and the projects they require access to.

thespecialist wrote: In Oracle stage it says I need to have sys.dba_extent access

You don't have the correct permissions within the Oracle Database.

thespecialist wrote: in sequential stage it says: parameter specified but not used in flow: DSProjetcMapName.

Are you running an NLS server install?

You can add the environment variable LD_LIBRARY_PATH to you Job properties - as a job parameter. Then specify the full path and file name of the *.so file at runtime.

Install DS 7.5 as you would normally
Install DS 7.5.1.a using the "-itag" option

Are you using static or dynamic libraries?
Is the strptime function library in the library path used at runtime by your job?

1) have you installed DataStage PX into the same path on all machines?
2) have you tested rsh using the machine names in your APT_CONFIG file?

Stored procedures must be called from a DataStage Job.
If your procedure is a before/after routine then the job does not have to do anything much for the procedure to be executed.

I would guess you are running out of memory. To achieve the same in a single job you would either have to reduce the number of nodes in your configuration.apt file or increase the amount of memory avaliable.

I agree this looks like the user permissions set on the Sun machine.
Out of interest what version of SunOS are you running?
What umask is set in the ds.rc start-up script?

If this was an Oracle problem you would expect an ORA-SQL error code. Do other parallel jobs run ok? As the error mentions "node node1" I would first check the Parallel configuration file works for other parallel jobs. Are you running sqlplus on the same machine that the DataStage Server i...

I belive 7.5.1.a will install on the same machine (on unix servers) and both will run, but the 7.5.1.a will use a different port to normal. Thus when you connect from your datastage client you must use <server>:<portnumber> or you will find yourself connecting to the 7.5 install.