Hi,
I am getting this error msg whenever I run a Job.
"
LoadDWItem..Trn_Process_Data: ORA-01653: unable to extend table FXDW.DW_ITEM by 8 in tablespace DWD "
Is it something related to the Database size or something else??
Cheers,
Victore
Search found 31 matches
- Fri Feb 25, 2005 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error Code
- Replies: 2
- Views: 1988
- Wed Aug 18, 2004 12:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Tuning DS server
- Replies: 20
- Views: 11033
Tuning DS server
Hi One of our client came with this request of Tuning their Jobs. When I checked the Job, they we quite ok, but the Performance was very much affected while running the Jobs. The DBA had informed that they have four CPUs, but I dont know whether Datastage is configured to use all the available CPUs....
- Fri Jul 09, 2004 2:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Typical Problem with Extraction
- Replies: 2
- Views: 1936
Typical Problem with Extraction
Hi, I have a requirement. I have to extract data from DB2 table which is largevarchar in DB2. the Maximum size of the field is 32K. The source data for this field is split into differect records and stored. When we extract the data, we have to concatenate them and store in a Hash File or Seq File fo...
- Thu Mar 25, 2004 2:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Typical Error in DS job
- Replies: 3
- Views: 2332
Thank you. I corrected the Problem
Hi,
Thank you very much, I corrected the problem.
Cheers
Victor
Thank you very much, I corrected the problem.
Cheers
Victor
- Wed Mar 24, 2004 9:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Typical Error in DS job
- Replies: 3
- Views: 2332
Typical Error in DS job
Hi,
Can some one help me.
I get an error like this "Parameter marker text size exceeds allocated space".
My job takes XML data and load to a Table. I update Old or Insert New Records in the Table
Cheers,
Victor
Can some one help me.
I get an error like this "Parameter marker text size exceeds allocated space".
My job takes XML data and load to a Table. I update Old or Insert New Records in the Table
Cheers,
Victor
- Thu Feb 05, 2004 2:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call a Routine in a Batch
- Replies: 2
- Views: 2080
How to call a Routine in a Batch
Hi,
I have a routine to Drive the first and last Date of Financial Year.
This I need to call in a Batch Job Control. Can some one help me to do that Please ?
Cheers,
Victor
I have a routine to Drive the first and last Date of Financial Year.
This I need to call in a Batch Job Control. Can some one help me to do that Please ?
Cheers,
Victor
- Thu Jan 15, 2004 9:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Delete the Source File in a Job after run
- Replies: 3
- Views: 2049
Delete the Source File in a Job after run
Hi,
I need to delete the data in the Staging source Table when the Job is Completed running. Is there any method to delete in the Job itself? can we do in the Plug ins or have to write a after job subroutine?
Cheers,
Victor
I need to delete the data in the Staging source Table when the Job is Completed running. Is there any method to delete in the Job itself? can we do in the Plug ins or have to write a after job subroutine?
Cheers,
Victor
- Mon Jan 12, 2004 12:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Roles & Responsibilities of a Datastage Developer
- Replies: 4
- Views: 7713
Tasks for Datastage Developer & Administrator
Yes kenneth,
You are right. I need to know about the tasks of a Datastage Developer
and Tasks of a Datastage Administrator
Cheers,
Victor
You are right. I need to know about the tasks of a Datastage Developer
and Tasks of a Datastage Administrator
Cheers,
Victor
- Sun Jan 11, 2004 7:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Roles & Responsibilities of a Datastage Developer
- Replies: 4
- Views: 7713
Roles & Responsibilities of a Datastage Developer
Hi,
Can some one tell where I can find a documentation for Roles and Resp of a Datastage Developer as well as Administrator.
Cheers,
Victor
Can some one tell where I can find a documentation for Roles and Resp of a Datastage Developer as well as Administrator.
Cheers,
Victor
- Fri Dec 05, 2003 2:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Get the Max ID of the Target Table in the Job
- Replies: 1
- Views: 1927
How to Get the Max ID of the Target Table in the Job
Hi,
I have a job where I extract the Results and get the Max ID of the Target Table and add 1 to write to the Target. I have taken the MAx id and add 1 to my Job. But since the Target File is a Big file, i am not able to Get the max id. IS ther any way to get the max Id of the Target table?
Cheers
I have a job where I extract the Results and get the Max ID of the Target Table and add 1 to write to the Target. I have taken the MAx id and add 1 to my Job. But since the Target File is a Big file, i am not able to Get the max id. IS ther any way to get the max Id of the Target table?
Cheers
- Wed Dec 03, 2003 10:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Ideas while handling Fact & Dimension Tables in Star Sch
- Replies: 13
- Views: 6883
Ideas while handling Fact & Dimension Tables in Star Sch
Hi,
I will be designing ETL for Fact & Dimension tables. Is there a document that I can refer when I need to Design ETL Jobs to handle Fact & Dim tables?
Cheers
I will be designing ETL for Fact & Dimension tables. Is there a document that I can refer when I need to Design ETL Jobs to handle Fact & Dim tables?
Cheers
- Mon Dec 01, 2003 3:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Line up the Grouping in Aggregator Stage
- Replies: 2
- Views: 1866
How to Line up the Grouping in Aggregator Stage
Hi, I have a requirement to group on more than one field. Say for example I need to group on ID_INTERNAL then CD_FORM, YEAR_OF_ASSESSMENT. How to I prioritise them? My first grouping should be on ID_INTERNAL and then CD_FORM and finally YEAR_OF_ASSESSMENT. Is there any way to line up the Grouping? C...
- Thu Nov 27, 2003 11:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to clear the Locks in DS?
- Replies: 4
- Views: 2399
How to clear the Locks in DS?
Hi
One of my Job is locked. I have been trying to clear the lock by cleaning up the resources. even then I can't clear the lock. Is there any any or any special command to clear them in the OS itself?
Cheers
One of my Job is locked. I have been trying to clear the lock by cleaning up the resources. even then I can't clear the lock. Is there any any or any special command to clear them in the OS itself?
Cheers
- Thu Nov 27, 2003 11:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to have Multiple Line Condition in a routine?
- Replies: 9
- Views: 4551
My Routine is like this. Can someone help?
Hi, My Routine is like this. IF ((CD_FORM1 = 300 And YR_RECEIVED1 = CY) And (CD_FORM2 = 393 And DT_RECEIVED2 > DT) And (CD_FORM3 = 990 And DT_RECEIVED3 > DT)) OR ((CD_FORM1 = 300 And DT_RECEIVED1 > DT) And (CD_FORM2 = 393 And DT_RECEIVED2 > DT) And (CD_FORM3 = 990 And YR_RECEIVED3 = CY)) OR ((CD_FOR...
- Thu Nov 27, 2003 12:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to have Multiple Line Condition in a routine?
- Replies: 9
- Views: 4551
How to have Multiple Line Condition in a routine?
Hi, I have a routine which has multiple If statement like given below eg: If (condition1 and Condition2... ) OR (condition3... And condition4....) Then Ans = 'ZZZ' Else (condition5.... and Condition6....) When I put the conditions in a single line then my routine works. If I put them in multiple lin...