DSXchange

Hi, six months back IBM person installed the datastage. But Job is hanging every half an hour. I have used one shared container and loop variables in my jobs. Is it problem because of this?.As of now we do not have any admin for my project. operating system - red hat linux. datastage - 8.5.0.1 datab...

Hi, I have to tune the below job. In both aggrigate stage I want to use hash partition.After that I want to clear the partition.Please correct me If i am wrong. Aggr-->Transformer funnel stage---> teradata teradatstage-->Filter stage ---> Aggri-->Transformer

Hi, For surrogate key creation my client asked us to use MD5 function. Sample function use: UPCASE(GETMD5(ACCTG_PROJ:CHAR(9):ACCTG_ACT:CHAR(9):BUS_UN_GL:CHAR(9):BUS_UN_GL_FROM:CHAR(9):BUS_UN_BD:CHAR(9):RESRC_SUB_CAT:CHAR(9):WRK_LOC_CD:CHAR(9):HM_LOC_CD:CHAR(9):DEPT_ID:CHAR(9):BULK_ALLOC_CD:CHAR(9):P...

thanks kwwilliams . I changed varient as 12.it is working. But I have one issue. my table is having 6,00,000 rows. with bulk option up to 420000 rows loaded properly. whenever I select more than 420000 it is not loaded. it is throwing below error. SRC_OPP_AVL,0: RDBMS code 2646: No more spool space ...

Hi, Job is keep on running because of Table is locked. But I am getting below error. Info: SRC_OPP_AVL,0: Generated SELECT statement: SELECT AVL_UID,SEQUENCE,DIR_UID,RES_UID,USR_ID,LASTUPDATE,RES_LEVEL,RSDATE,RFDATE,CLH_UID,PALLOC_UID,SRC_SYS_ID,LOAD_ERROR,DATA_ORIGIN,CREATED_EW_DTTM,LASTUPD_EW_DTTM...

I set the MALLOC_CHECK_=0 in job level and administrator side also.

Now above warnings are gone. But job is kepping on running.

Please help me

after changeing to bulk mode I am getting above warnings and fatal error.

Hi, Thanks your mail. my job: teradata connector stage -> transformer -> teradata connector stage But I am getting below warnings and fatal error warning: SRC_OPP_AVL,0: *** glibc detected *** /opt/IBM/InformationServer/Server/PXEngine/bin/osh: double free or corruption (out): 0x000000000230c760 ***...

Hi,

I have worked in teradata connector stage as target.But I did not work as source. Now I need to use as source. For increase performence can I know the what properties I need to set.

arrry-size- 2000
record count-2000
access method- immediate
parallel synchronization- no

My job :
oracle connector stage-> transformer -> teradata connector stage
we asked client for sample data for long raw column. They provided
above data. I tried insert(manually) into the oracle database.
But I could not.

we asked the sample data for the long raw column. But sample data contains more than 4000 characters. If I am trying insert into long raw column it is throwing error.it is allowing me up to 4000 characates. sample data: 0400060000001200000026020B0000004561726C7920446174657308000000416374697669747917...

Thanks ray . that compilation error is gone.

But I ran the job. in the target table(teradata) i did not get any value for this column. it is stored some junk characaters. I am unable to see the proper value.In the transformer I have used below code.

RawToString(in_RawToString(in_OPP_BRS.DATA)

Hi, My job : oracle connector stage-> transformer -> teradata connector stage in source DDL there is a column as data. datatype is LONG RAW. while imporing into oracle connector stage it is takeing as longvarbinary. my target column data type is varchar(4000). but while I am compileing my job I am g...

Hi, During datastage client installation Microsoft .Net Framework 1.1 is successfully installed but while installing the Microsoft Framework 4.o it throws the following error: com.ibm.is.install.exception.InstallException: CDIPR2040E:Unexpected return code -939,523,085. and because of this error the...

I ignore above warning. I started continue the installation. unable to create
plugin db2 database. I think because of the above warning unable to create db2. Have you come across this issue?