DSXchange

The 64BITFILES option in the uvconfig file is working

We missed one of the regen steps - when we did it - it worked fine.

Thanks for all the help

Did the uv regen
Added the file via the command line.
It gets up to 2.1GB and then just hang there - job doesn't fail - doesn't complete.
Could it be a limit in version (11)?

So I have set the ulimit on OS level and in the dsenv file ulimit -d unlimited ulimit -m unlimited # ulimit -s unlimited ulimit -s 4194304 ulimit -f unlimited ulimit -n 4194304 In the uvconfig file I have set the 64BIT_FILES 1 Database to Hash - about 220 Mil records to be written to the hashfile Th...

I will try the delimted way. But surely there must be something easier. This was previously done by a control job.

Leonie

Hi Craig I'm using the Userstatus is other jobs but only if I need only value - can you use the Userstatus more then once in one job? Doesn't it overwrite it? Other thing the parameter will be used in the next job as part of the "in list" on a table. (List of account numbers) Thanx Leonie

Hi Mark

All sources are datasets or sequential files, no databases.

Leonie

This is on the commandline and as far as I know you cannot export to XML on the commandline - it is always DSX.

Manager - in Enterprise there is no manager?

Hi I manage to get this to work on an other server - same command - just different client. I did that Yesterday - today it doesn't work I get the following. Same command same client but this error. Attaching to 'project1' ... dscmdexport aborted: Failed to attach to the project This is really frustr...

Hi all I'm using the commandline utility to automate our Datastage exports. I have schedule the batch job to run everyday but I have encountered the following problems Command C:\IBM\InformationServer\Clients\Classic\dscmdexport /H=hostname /U=user /P=passw /O=omitflag project1 c:\DSExports\Producti...

Hi Tania, We have the similar problem on AIX DS 7.5.1.A The IQ bulkloader doesn't overwrite the .DAT file it only overwrites the .SQL and only if you are the same user. If you logged in as a different user then it will give you an error about can't access or write to that file. First we though it wa...

I do have other DB2 database - they all run on AIX. They worked without having to bind then. The problem is when I try to connect to the MAINFRAME (OS390). The other connections is also using the same driver, so I think the driver is fine it is the Mainframe part that is tricky. Here is an example o...

Hi Mat, I not sure but this is my LIBPATH at the moment. Is something missing, do I need more entries? I did stop and start the services after adding the libraries. [galaxy:dsadm]/home/datastage> echo $LIBPATH /opt/sybase/OCS-12_5/lib:/home/IQ/ASIQ-12_6/lib:/home/IQ//home/IQ/OCS-12_5/lib :/home/IQ/A...

I had the same problem and added the odbc libraries to the LIBPATH when I execute the bind20 script I get the following. USAGE: ./bind20 <DSN> But if I put the the DSN name in I get the following. [galaxy:dsadm]/home/datastage/Ascential/DataStage/branded_odbc/lib ./bind20 Hogan Specified driver coul...

This is more of a wish list. In version 7 of Datastage you had the option when viewing the data to select all the data and copy it into Excel/Word or any other source. In the new release 7.5 that option disappeared. Why? I think this is a step backwards by taking away. Can you please bring this back...