DSXchange

Hi Ray, here is what i see from the job log for environment variables Environment variable settings: _=/usr/bin/nohup LANG=C LOGIN=dsadm LDR_CNTRL=MAXDATA=0x30000000 LOGNAME=user123 . . . . .APT_CONFIG_FILE=/dsadm/Ascential/DataStage/Configurations/Proj.apt APT_DEFAULT_TRANSPORT_BLOCK_SIZE=32768 APT...

Hi Ray, i used the same user id to run the command at UNIX command level and logged to DataStage with same ID and executed the same via a routine. And i did check ULIMIT in uvconfig file it is set to 128000, but i am not sure it is overriding the value while running the ulimit -a via datastage routi...

Hi gurus, we are having Heap size allocation errors - we have 2 TB of scratch space but still jobs are failing when we run huge volume of data. I read in message board to look for the ulimit for the id which i am using to run the jobs. on unix command line ulimit -a shows time(seconds) unlimited fil...

Ii verified the COL1 - is on hashed file columns and with same case (upper case)

Thanks Chulett,

i created a VOC entry for the hashed file and it was successful but when i tried to crate index
CREATE.INDEX <hashedfilename> <COL1>
it throws out error message as below - any thoughts?

Thanks Chulett,

i created a VOC entry for the hashed file and it was successful but when i tried to crate index
CREATE.INDEX <hashedfilename> <COL1>
it throws out error message as below - any thoughts?

hi, I am trying to add a Index via Admin GUI as below CREATE.INDEX <filename with Path> COL1 it throwing "<filename with Path> is not a file name" Any idea, why it is not taking the path and file name, am i missing anything before creating an Index on Hashed file? Any info is appreciated!

Hi, One of my SQL Query to select records from Oracle table causing an issues to retrieve the data from table. Job aborted after running about 10 hrs saying that "Snap shot too old". We verified the Sql at the database side - query is reformatted at the database side by adding /*+rowid(p)*...

Thanks for the info Ray.

Thanks Ray, it is issue with the db2 libraries, DBA installed 64 bit libraries and it is pointing to 64 rather than 32 bit. Once that is set back to 32 bit drivers i am able to connect to DB2. I have a question, does it matter if we source 64 drivers first and 32 bit drivers later in profile? Thanks

Hi, I tried the site and i got information but after doing all the necessary thing still i am getting the same error SQLSTATE=IM003 I am using libdb2.so , our environment is Unix Aix - and the database i am trying to connect id DB2 8.0 1) added .odbc.ini file with odbc driver information 2) changed ...

Thanks Ray, When I did Ulimit -a at command line with production id which we are running etl job here is the result time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) unlimited memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) 2000 Where are i ...

Hi Ray, I found the reply to one of Fork error issues - You mentioned to add a call to DSExecute() to invoke a ulimit - how do i do that? Any information is appreciated. No but you can. Add a call to DSExecute() to invoke ulimit -a and write the result into an informational log entry. This will let ...

Thanks Ray and ArndW

Got the Answers!

Hi,

Is there a way to compress .ds dataset files to different location?

Thanks,