Search found 14 matches

by hassers
Thu Oct 06, 2005 11:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: AIX prerequisite
Replies: 3
Views: 1600

Sorry didn't make it blindingly clear
For enterprise require full Visualage compiler / runtime the works.
For Server only need Visualage runtimes
by hassers
Thu Oct 06, 2005 11:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: AIX prerequisite
Replies: 3
Views: 1600

Previous response was correct for enterprise. For Server we've found during upgrade 7.0 to 7.51 Make sure you have runtime equivalent to those stated in Setup guide. We had to upgrade to ViaualAge v6 (Nov 2004). Had problems installing later edition, pulled software off IBMs web site. Also double ch...
by hassers
Mon Sep 26, 2005 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJOB getting details of Warnings / Fatals
Replies: 4
Views: 2396

Thanks for the information.

I'm creating a test script to see how to complete this.
Also thought of running -lognewest before and after job and picking up the range.
by hassers
Fri Sep 23, 2005 10:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJOB getting details of Warnings / Fatals
Replies: 4
Views: 2396

Thanks for that.

However, I need to put this into a UNIX batch script running overnight.

Could anyone suggest a way I can link dsjob - lognewest giving the newest log with dsjob - logsum so I can pull the latest log.

I'm NOT a shining star on UNIX scripting so am very grateful for any advice.
by hassers
Fri Sep 23, 2005 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJOB getting details of Warnings / Fatals
Replies: 4
Views: 2396

DSJOB getting details of Warnings / Fatals

I'd be very grateful for advice Have created a UNIX script that runs our DataStage jobs. After the JOB has run check the log file for either Warning or Fatal messages. strConnect="$DSBin/dsjob -server 127.0.0.1 -user $DStageID -password $DStagePASS " $strConnect -logsum -type WARNING $DSPr...
by hassers
Wed Sep 01, 2004 9:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control
Replies: 4
Views: 2847

Check the version

I'd double check the version your using and contact Ascential for latest fixes. Originally used 7.0 which won my ' Rubber Spanner Award' There were a number of bugs which were fixed and released. Still not really impressed, but it is better. We also had issues with permissions from our DEV server to...
by hassers
Tue Aug 17, 2004 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: process any and all sequential files in a directory
Replies: 7
Views: 3107

I have a group of files coming into a specific UNIX Subdirectory, they were all of the same format. I run a DataStage job in the parameters I have the before Stage set the ExecSH The script concats the files in the subdirectory to a single file. and then moves the data files to an Archive. It seems ...
by hassers
Tue Aug 17, 2004 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help - Abort after XX Warnings
Replies: 1
Views: 1210

Help - Abort after XX Warnings

We have an informal standard here in that we automatically set ABORT after 250 warnings on jobs. We'd like to make this a more formal standard (accepted there'll always be exceptions). Is there any way I can apply this setting to all our jobs? Anyone created a utility for such an event? Advice grate...
by hassers
Thu Aug 05, 2004 4:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stripping Non Printing Characters
Replies: 5
Views: 3027

Alternat Routine Code

Very similar to Rays Code, do initial check for null string being received and stip trailing spaces: Input variable SourceString Ans = '' lenvar= len(trimb(SourceString)) if lenvar < 1 then Ans = ' ' For i = 1 to lenvar step 1 char1 = SourceString[i,1] nchar = seq(char1) if nchar <32 or nchar>127 th...
by hassers
Mon Aug 02, 2004 5:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The specified module could not be found.
Replies: 5
Views: 2526

COnnecting to DB2 via ODBC

I'd check that the user account allows multiple sessions / connections?
- but would expect a better error message.

Security on an IBM Mainframe - Aghhh - Joy on monday morning .
by hassers
Wed Jul 28, 2004 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clear the "deleted jobs" from repository vi
Replies: 15
Views: 8800

Tidy-up

Check Out DS Administarator and complete a clean-up on the project.
Make sure know one has any jobs open in the project.

Go back into the project and see if they are still there.
by hassers
Wed Jul 28, 2004 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: going to universe from unix
Replies: 4
Views: 2448

Run UV

1) When you sign onto the UNIX server you'll normally default to a user home account Eg. /home/dsadm 2) It worth copying a version of dsenv to this subdirectory and set priviledges (chmod 766) to run the set-up parameters. 3) Then type . ./dsenv to setup the DataStage environment settings within the...
by hassers
Wed Jul 28, 2004 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export routines, transforms etc. from code
Replies: 3
Views: 2657

Creating Export via command line

On a related issue, we had difficulty running DS Manager to complete an export of project. We were informed of the dos command dscmdexport. Please note there can be issues if run whilst objects are locked by users. dscmdexport command The dscmdexport is as follows: dscmdexport /H=hostname /U=usernam...
by hassers
Thu Feb 05, 2004 1:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSJob -logsum
Replies: 1
Views: 3254

DSJob -logsum

DS v7, Server UNIX AIX Have created a UNIX script that : - picks up parameters, - initiates DSJOB RESET (if required) - runs the DSJOB The issue is at the back-end picking up results of the Job Using a DSJOB - LOGSUM - this picks-up WARNINGS and FATALS Problem is that this returns WARNINGS / FATALS ...