Search found 42189 matches

by chulett
Thu Apr 13, 2006 7:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Source- incorrect number of result columns.
Replies: 13
Views: 6785

More than likely because it wasn't exactly the same. The trick is figuring out what the difference was...
by chulett
Thu Apr 13, 2006 7:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Client Slow response
Replies: 17
Views: 9994

For example, it just took me 1.5 minutes to open a job with 7 stages in it. This particular project has 229 px and server jobs. That's still a 'small' number of jobs and by itself won't account for the delay in opening the job. For example, my current project has 1,439 jobs and it just took 40 seco...
by chulett
Thu Apr 13, 2006 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Excellent! :D
by chulett
Thu Apr 13, 2006 12:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Coldfusion? Not sure what that would have to do with anything. If you aren't sure what's going on, change the Link Tracing Level property from its default of zero to something else so it can tell you what the problem is. With your cursor in the field, click on Property Help to see what values can go...
by chulett
Thu Apr 13, 2006 11:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

srimitta wrote:Can I use command rm <file name> in 'Telnet After', will this serve my purpose.

Possibly, depending on permissions and such. Give it a shot and see.

Make sure you've got all of the Telnet Prompts setup correctly in the stage so it can logon properly after the ftp is complete.
by chulett
Thu Apr 13, 2006 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Actually, you can do things like this via the FTP stage. Check out the 'Telnet Before' and 'Telnet After' options on the Input / Properties tab. (Scroll way down)

Or just use a shell script instead of the stage. :wink:
by chulett
Thu Apr 13, 2006 10:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgrade DS server 7.5 to DS server 7.5.1.a
Replies: 8
Views: 2535

Actually, there are quite a boat-load of fixes between 7.5 and 7.5.1a... the former was quite buggy, apparently. I believe there is a patch for a particular issue with the OCI stage and the stoopid 'SQL Builder Tool' but you can check into stuff like that post-upgrade. Good to see you back, Ogmios. ...
by chulett
Thu Apr 13, 2006 8:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: upgrade DS server 7.5 to DS server 7.5.1.a
Replies: 8
Views: 2535

There's no patch needed. As noted, make good backups and then simply install 7.5.1a right over the top of 7.5. Easy as pie. :wink:
by chulett
Thu Apr 13, 2006 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: about Datastage Job Backup
Replies: 6
Views: 3198

That is the 'best' and most common way to backup jobs. The other way is a 'normal' filesystem level backup so that the full DS installation and things like your hashed files are backed up as well. Also you'll find things like 'uvbackup' (?) to backup individual hashed files, but I don't think many p...
by chulett
Wed Apr 12, 2006 7:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Client Slow response
Replies: 17
Views: 9994

roblew wrote:We did consider using a citrix setup, where they would log into a session and run it from the network. Would that be preferred (faster)?

Yes, both. Enormously. :wink:
by chulett
Wed Apr 12, 2006 7:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to compile test harness
Replies: 8
Views: 3455

Again, don't compile/run/test things in the VC project as it will just cause you grief because every object is renamed there. Your first error message implies that the routine that was 'never dimension' has never been promoted to your Production project. Promote it again, even if you think it's alre...
by chulett
Wed Apr 12, 2006 7:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Moving Resized Hashed files
Replies: 8
Views: 2217

Since the 'resize' step is a manual step, you would need to redo it every time the hashed file is (re)created. That would include the first run in a new environment.

Hopefully the job that populates it doesn't have the 'Delete' option checked so that it gets recreated each run. :wink:
by chulett
Wed Apr 12, 2006 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller problem- need to modify UV parameters
Replies: 7
Views: 3890

nkln@you wrote:I can find this uvconfig file in home directory of ascential. Does it mean that it is unique to server.

Yes. As noted, though, are you sure this is the cause of your problems? What 'controller problems' are you seeing, exactly?
by chulett
Wed Apr 12, 2006 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage warning error
Replies: 7
Views: 1993

Exactly. Error message fully states the problem, now you just need to find where it is being called in the job.
by chulett
Wed Apr 12, 2006 6:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Comparing in Transformer
Replies: 2
Views: 1219

In that format? No. You need to either get them both in 'YYYY-MM-DD' format or convert them to internal format (using IConv) before you compare them.