Search found 1315 matches
- Thu Feb 23, 2023 12:30 pm
- Forum: General
- Topic: Datastage Health check
- Replies: 2
- Views: 7685
Re: Datastage Health check
Well it really depends upon your level of comfort when saying "it is up". I will assume a Linux back end host for this example. 1) You could look for dsrpcd pid. - if that is not running you are dead in the water. 2) You could look for the java pids associated with websphere. - webphere no...
- Tue May 31, 2022 1:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multiple lines of data into a single line.
- Replies: 3
- Views: 10089
Re: Concatenate multiple lines of data into a single line.
Shell script with a loop.
start of loop:
$line1=read the line from input;
$line2=read the line from input;
$line3=read the line from input;
echo it to the output "$line1 $line2 $line3";
end of loop
if condition the loop to beak out once you reach the end of file.
start of loop:
$line1=read the line from input;
$line2=read the line from input;
$line3=read the line from input;
echo it to the output "$line1 $line2 $line3";
end of loop
if condition the loop to beak out once you reach the end of file.
- Fri Jan 21, 2022 11:31 am
- Forum: General
- Topic: Same lookup on multiple rows
- Replies: 1
- Views: 9400
Re: Same lookup on multiple rows
Since it is a sequential file to begin with, I would do it from a command line and not DataStage logic.
https://stackoverflow.com/questions/132 ... ell-script
sed command for string replace and make it with the /g option
https://stackoverflow.com/questions/132 ... ell-script
sed command for string replace and make it with the /g option
- Fri Dec 31, 2021 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CALL UNIX SHELL SCRIPT FROM JOB
- Replies: 4
- Views: 11640
Re: CALL UNIX SHELL SCRIPT FROM JOB
Have you thought of using a build op?
- Fri Dec 31, 2021 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CALL UNIX SHELL SCRIPT FROM JOB
- Replies: 4
- Views: 11640
Re: CALL UNIX SHELL SCRIPT FROM JOB
There is a Stage for that. Try the External Source Stage I believe.
- Thu Nov 25, 2021 9:39 am
- Forum: General
- Topic: Issue with Special Character Data
- Replies: 1
- Views: 10359
Re: Issue with Special Character Data
Is the program you are using to view the database table able to display that character set?
Does the database table contain the hex value of those characters?
Is that special character even present in a UTF8 character set?
Is the Database table schema valid for that character set?
Does the database table contain the hex value of those characters?
Is that special character even present in a UTF8 character set?
Is the Database table schema valid for that character set?
- Tue Oct 12, 2021 10:48 am
- Forum: General
- Topic: Job Logs for most recent execution (XMETA SQL)
- Replies: 2
- Views: 11846
Re: Job Logs for most recent execution (XMETA SQL)
Personally I would use DSODB tables to identify the latest project/job/status and then follow up with a dsjob -logdetails extract to get the logs. I would avoid direct queries to xmeta because a bad user written script could impact your production ETL flow. Impacting DSODB will not halt your ETL flow.
- Thu Sep 02, 2021 11:36 am
- Forum: General
- Topic: Ghost town in here
- Replies: 1
- Views: 10926
Ghost town in here
Are fewer people logging into this site or is it that fewer people are asking questions? I know that Information Server has been around for awhile but is the lack of activity here indicative of a move away from this tool in the industry? I like it (biased answer of course) but it's not "open so...
- Wed Aug 04, 2021 9:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: New v11.7 server getting "PRINTER memory segment removed" job log warnings
- Replies: 5
- Views: 15398
Re: New v11.7 server getting "PRINTER memory segment removed" job log warnings
look inside uvconfig. Look at the paths defined in there, perhaps one is missing...
- Wed Aug 04, 2021 7:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: New v11.7 server getting "PRINTER memory segment removed" job log warnings
- Replies: 5
- Views: 15398
Re: New v11.7 server getting "PRINTER memory segment removed" job log warnings
What has your research into your missing uvconfig path? Did you validate everything in there?
- Mon Aug 02, 2021 1:09 pm
- Forum: General
- Topic: Websphere 9.x snake in the grass
- Replies: 0
- Views: 10706
Websphere 9.x snake in the grass
For the DataStage admins our there... you might want to go out and look at your /root path/mount (which defaults to / mount) and see if you are amassing some garbage collection files. Over time you run the risk of filling up the / mount (unix) if you do not address this. https://www.ibm.com/support/...
- Mon Jul 26, 2021 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16916
Re: Join Stage slowness in parallel job
Any speed improvement?
- Mon Jul 26, 2021 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to set the path for the heap dump files via DS project environment variables
- Replies: 3
- Views: 13368
- Wed Jul 14, 2021 1:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16916
- Wed Jul 14, 2021 6:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16916
Re: Join Stage slowness in parallel job
1,000,000 / 200 = 5,000.
Try that as your array size.
Try that as your array size.