Search found 28 matches

by ashcar
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...
by ashcar
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...
by ashcar
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...
by ashcar
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...
by ashcar
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

Be careful if using QualityStage, however, because it insists on Bourne shell. Its own "shell executable" is a symbolic link to /bin/sh. i have qualitystage on the same server but different project..works fine after tweaking with all help from DSXchange...but the parallel extender warning...
by ashcar
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...
by ashcar
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

So where is the PWD environment set for Parallel extender.. to get rid of that warning ...
in some earlier posts it was mentioned to change from#!/bin/ksh to #!/bin/sh ..in dsenv file .that did not help ..
any suggestions ???
by ashcar
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 ...
by ashcar
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

Just got the news from Ascential Support that..particular environ ment os disabled in DataStage 7.5
by ashcar
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...
by ashcar
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...
by ashcar
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 ???
by ashcar
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
by ashcar
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

This is a new PX installation ..what does that parameter "DSProjectMapName" mean i have no such parameter in stage properties ..if that has to do something with my DSENV or any settings please help Hi, Fix the first error Parameter specified but not used in flow: DSProjectMapName Still if ...
by ashcar
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...