Search found 28 matches
- Tue Oct 24, 2006 12:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to delete these scratch files after sort
- Replies: 7
- Views: 4374
... unless /tmp is very small, which it often is on Solaris especially (and they mount swap there also!) Our filesystem space for /tmp in AIX 5.3 is very small so instead will take the Crontab approach to find and delete allover the DataStage projects. every user who ran sort jobs had directories w...
- Mon Oct 23, 2006 3:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to delete these scratch files after sort
- Replies: 7
- Views: 4374
how to delete these scratch files after sort
I have long list of directories in my project folder which i suspect are scratch files after sort, /proj/dsadm/Ascential/DataStage/Projects/Dvl so-O3nUa so-_mnia so3vQjEa so4JQa7a so4xedya so5hYbaa so9-Qoya soPDijMa.................................. these directories cannot be deleted even by the ow...
- Mon Jan 31, 2005 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PWD Environment Variable warning
- Replies: 12
- Views: 6422
someone described it before and the easiest way is creating a Environment variable at project level from Administrator ---> PWD and give the default path pointing to the warning, in my case --->/proj/dsadm/Ascential/DataStage/Projects/MIdvl create PWD variable for each project and insert them in eve...
- Mon Jan 24, 2005 10:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi-instance job
- Replies: 2
- Views: 2202
Multi-instance job
Hi, I have a multi-instance sequence job which runs for N number of load id's which vary everyday, only after this all the N load id's are done i would like to start another Multi-instance sequence which processes all the load -ids processed by the earlier job .....is there anyway in DataStage where...
- Thu Jan 20, 2005 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PWD Environment Variable warning
- Replies: 12
- Views: 6422
- Thu Jan 20, 2005 1:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PWD Environment Variable warning
- Replies: 12
- Views: 6422
Go Datatstage admin and select your project and on General tab click the environment button and goto user defined category and create a ENV variable called PWD with the correct path of the project. this should be the path where Project is sitting. cheers, Siva. that does not work .. tried inserting...
- Thu Jan 20, 2005 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PWD Environment Variable warning
- Replies: 12
- Views: 6422
- Thu Jan 20, 2005 11:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PWD Environment Variable warning
- Replies: 12
- Views: 6422
PWD Environment Variable warning
I know this warning has been discussed before but can somebody tell exactly where do i make a change before.. because after every change in .dsenv to setup PWD ..i have to stop/start DSengine ... i am like a :twisted: in the group my Unix Admin has a question "Where is the environment variable ...
- Mon Dec 13, 2004 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Syntax for APT_ERROR_CONFIGURATION
- Replies: 1
- Views: 1612
- Wed Dec 08, 2004 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Wrapped Stage
- Replies: 1
- Views: 1529
Using Wrapped Stage
I have a server job ..where it executes a shell command to move the files in the after stage routine... since i have converted that job into parallel i need some help building wrapped stage...the shell command is mv #ArchivePath#/Sorted#FileToSort# #ArchivePath#/#FileToSort# how do i pass job parame...
- Thu Dec 02, 2004 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Syntax for APT_ERROR_CONFIGURATION
- Replies: 1
- Views: 1612
Syntax for APT_ERROR_CONFIGURATION
Hello, I get warning messages while running a job....those warnings are harmless and the job runs fine..i would like to get rid of warnings only can anybody tell me the proper syntax for the environment variable APT_ERROR_CONFIGURATION.... APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, module...
- Wed Dec 01, 2004 2:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Before & After Sql in ORacle Stage
- Replies: 2
- Views: 2389
Using Before & After Sql in ORacle Stage
I have a Server job ..where i drop Indexes and build Index in after and before Sql in Oracle stage...but since going to Parallel Extender...i cannot find a similar screen in Oracle Enterprise stage....
how do i put in the before and after SQL for dropping indexes ???
how do i put in the before and after SQL for dropping indexes ???
- Thu Nov 11, 2004 12:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert DATE in internal format for comparison
- Replies: 5
- Views: 3258
How to convert DATE in internal format for comparison
In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values..
how can ido the same in parallel extender...
tried using DatetoString but does not work for me
please help
how can ido the same in parallel extender...
tried using DatetoString but does not work for me
please help
- Tue Nov 02, 2004 8:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing flat file in Px
- Replies: 6
- Views: 5758
- Fri Oct 29, 2004 9:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing flat file in Px
- Replies: 6
- Views: 5758
Error viewing flat file in Px
I get the following error when i try to view the sequential file using PX sequential file stage the metadata for this job comes from a previous server job Its a fixed width flat file .. any suggestions Error executing View Data command: ##E TOIX 000139 10:28:25(007) <Sequential_File_4> Import valida...