Search found 27 matches
- Wed Feb 06, 2008 5:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to Update Universe Table
- Replies: 3
- Views: 1963
Unable to Update Universe Table
Hi All, I am trying to update some columns in universe table based on one column.for that I selected "Update Existing Rows Only" update action.On Execution, its giving me the following error "[DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error. Unexpected symbol. Token was &q...
- Sun May 13, 2007 8:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar Type key field in Universe Hash file Stage
- Replies: 9
- Views: 5140
Use SETFILE in a project to create a VOC pointer. Then issue the CREATE.INDEX command. You can remove the VOC pointer afterwards if you wish. ... Hi ray, thanks for pointing this out. I already had VOC pointers created for the hash files , however I was trying to create indexes on the physical hash...
- Sun May 13, 2007 8:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar Type key field in Universe Hash file Stage
- Replies: 9
- Views: 5140
Hi ray, Yes i did replace the syntax with actual file names and field names. I typed it this way just for everyone else who reads this topic to understand what I am trying to say :) But the point is that i still get the error. It may be noted that this hash file resides in unix file system, not in t...
- Sun May 13, 2007 8:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar Type key field in Universe Hash file Stage
- Replies: 9
- Views: 5140
- Sun May 13, 2007 7:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar Type key field in Universe Hash file Stage
- Replies: 9
- Views: 5140
- Sat May 12, 2007 12:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar Type key field in Universe Hash file Stage
- Replies: 9
- Views: 5140
Varchar Type key field in Universe Hash file Stage
Hi, I am using a combination of Varchar type key field and an integer type key field to be looked up through a hash file in a universe stage for date range lookup. The lookup file contains merely 50000 records, however the lookup operation on this file has become damn slow @ 3 rows/sec. It may be no...
- Wed Nov 15, 2006 12:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: RT_LOGxxx Not Found
- Replies: 9
- Views: 4468
- Wed Nov 15, 2006 12:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to clear RT_LOG****
- Replies: 6
- Views: 12705
How to clear RT_LOG****
HI All,
One of the lof files has reached a size of 2GB.. I am unable to clear it by the clear job log option in director.. The operation hangs and gives some error..
Can anyone tell me how to clear this log file? Is it safe to delete its content from Unix???
Regards
One of the lof files has reached a size of 2GB.. I am unable to clear it by the clear job log option in director.. The operation hangs and gives some error..
Can anyone tell me how to clear this log file? Is it safe to delete its content from Unix???
Regards
- Tue Nov 14, 2006 10:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
- Tue Nov 14, 2006 10:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
How many jobs are there in the project? If they are not hugh in numbers. My advise could be taking export of the entire project with the executable and creating a different project with that, then you can make a comparison actually, since you have said that you are auto purging the log and you are ...
- Tue Nov 14, 2006 10:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
- Tue Nov 14, 2006 9:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
Check which files are relatively big in size and what is their type (log,RTBP,temp file)? Just classify the space utilized by the different types of file, that may lead to some clue. There are a lot of 'TEMP*', 'RT_LOG*' and 'RT_STATUS*' files in the project directory, But I feel these files are ge...
- Tue Nov 14, 2006 9:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
Are there any jobs running with large number of warnings, if yes, then try to modify the jobs in such a way that you don't get warnings at all. Hi Loveojha2, As long as the Auto purge feature is enabled in ds admin, it dsnt matter even if the job gives warnings.. I have already tried all that.. Any...
- Tue Nov 14, 2006 9:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
- Tue Nov 14, 2006 9:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage server directory running out of space
- Replies: 17
- Views: 7690
Datastage server directory running out of space
Hi Friends, I am facing this issue of Datastage server directory on UNIX "Ascential/Datastage" running out of space frequently. My system administrator keeps increasing the size of the directory but in a matter of 10 days the directory has grown from 8 GB to 11 GB in size!!! I am baffled b...