DSXchange

Hi

I found this message in IBM site.

57014 Processing was cancelled due to an interrupt. The execution of a query is canceled due to user inter

Hi While i am reading data from Mainframe table using DB2API stage. I am getting this Fatal Error. Please respond with valuable information. I guess this is happing because of operation log full. ------------------------------------------------------------------------------- MF_IML_Extract,0: Fatal ...

Hi I design a job to find out missing data. But i have find out Reject data that is why i am using Lookupstage. i got below message . Lkp_HD_HS,0: Could not map table file "/DataStage/data/DEV/Datasets/lookuptable.20100831.qq5u5ka (size 3373708168 bytes)": Invalid argument Error finalizing...

Thanks

My Logic is working fine.

Hi I have a conversion job, job is working fine. But one of the column data is not matching when compare to production. column data type is Char ( 9 ) In my production table the data is like this 000000001 000006535 000000023 009864321 After i ran job the data is loading in this format 1 6535 23 986...

Hi I am comparing two tables to find out missing data. The job is like this Table A ----- Lookup--- Table B ( Ref Table ). Take two out put files, one as Rej_File. Both Table A and Table B columns are same but two different tables. When i ran the job i am getting below warning. Lookup_156: When chec...

Hi I try to install IBM DataStage 8 It was installed IBM DataStage Qualitystage IBM Information Analyzer IBM DB2 COPY IBM DB2 MetaData for Information Analyzer WAS also. i can log in to Web Console and Admin Console but when i try to login in to DataStage it is asking Domain name, DataStage server a...

Thank you Hulett Ya i raised this issue to my DBA. I explained to him these jobs are working fine when i ran first time on another schema. I also tried to use below Orchestrate query to delete the records. DELETE FROM #DBSchema#.DBSLS WHERE SRKEY= ORCHESTRATE.SRKEY; DELETE FROM #DBSchema#.DBILN WHER...

Hi I design two datastage to fetch (not match records ) and delete perticular SRKey records in the table. First job is Table A is join with Table B using key column SR_KEY using LookuStage. Take two target Sequential files ( Rej_File and Output_File ) Second job Rej_File as source and using transfor...

I fixed the problem.

Hi I am getting below warnings, when i ran the job. Earlier this job is under default.apt, Now i am running on Four node system. Sort | | JOIN <---- Funnel | | Out put to Transformer I put preserve partition as Clear in all these stages. ========================================== 1:--ISM_join_ICU: W...

Thank you for All

I fixed this issue.

In my job some of the source columns ( NULL) are mapped with Not Null columns in the target , while inserting the data. I am getting the warnings.


how can i avoid these warnings.

Hi

I am getting this warning.

Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=9, COLNO=94" is not allowed. SQLSTATE=23502

Please respond with useful information.

Thanks
SReddy

Hi I am getting below warning when i ran my job. Mostly these wornings are at Join stage and lookup stage. When checking operator: Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0. Please respond with useful answer....