Search found 42189 matches

by chulett
Thu Apr 12, 2007 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage on Unix vs Datastage on Windows
Replies: 4
Views: 2727

Re: Windoze might be better for RPG.

rameshrr3 wrote:I worked with DS on windoze for about 3 years

With Ken Bland? :wink:
by chulett
Thu Apr 12, 2007 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Improve a difference between two dates
Replies: 7
Views: 4761

In other words, just use IConv to convert both date portions to 'internal' (integer) format and subtract them - the answer will be the difference in days. If you really want to use the 'DateGenericDateDiff' transform, it uses the 'DateGenericToTimestamp' transform to transform the date and handles q...
by chulett
Thu Apr 12, 2007 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Weird Error Message
Replies: 16
Views: 6612

What are the permissions you have on your Project directory?

Since you've jumped on the end of an old thread rather than start your own (and link back to this one) we have to ask things like - is your Server installed on UNIX or Windows?
by chulett
Wed Apr 11, 2007 10:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the statisics after execution of the job
Replies: 2
Views: 934

You might want to explain exactly what "it was enabled" means. Do you know if your JobMonApp is running? Here is post on the subject, a search for that term will turn up several more.
by chulett
Wed Apr 11, 2007 9:35 pm
Forum: General
Topic: Timestamp to week day in String (mon, tue)
Replies: 5
Views: 1783

You should have just stayed in your original thread. No reason to start a new one and break the relationship, one to the other. Are you trying to follow Ray's advice there? What was your exact TimestampToString function used? The FIELD function just returns a portion of a delimited string and was me...
by chulett
Wed Apr 11, 2007 7:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the table used by datastage jobs.
Replies: 3
Views: 13114

Yes, there are queries you can run in the Administrator or at a TCL prompt against the DS_JOBS and DS_JOBOBJECTS repository tables. They've been posted here many times, a search for those table names should turn them up. Mostly from our resident guru Mr Kim Duke. Also, Chuck Smith has a job to parse...
by chulett
Wed Apr 11, 2007 7:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration From Dev to Testing
Replies: 2
Views: 1368

Not sure what you are asking. If you will be using Version Control to do your promotions, there are no other steps in the dev environment. The process starts and stops with VC. Or are you asking about setting up Version Control? That's covered in the manual and involves setting up at least one dedic...
by chulett
Wed Apr 11, 2007 6:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling
Replies: 4
Views: 1332

First off, you've marked your Server OS as 'Windows' in your post, is it really on UNIX? In any case, 'scheduling' is handled automatically by the Director tool. All you need to do is 'Add to Schedule' and it will create the appropriate entries for cron or at for your job. For UNIX, you will need to...
by chulett
Wed Apr 11, 2007 1:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can We Recover deleted job
Replies: 10
Views: 7660

The fact that a delete was performed is logged in the DS_AUDIT table. But nothing else is logged and none of the deleted information is saved out there.
by chulett
Wed Apr 11, 2007 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can We Recover deleted job
Replies: 10
Views: 7660

No, they are not stored in anything like a 'Recycle Bin' where you can simply click 'Undelete' and get it back. They are gone. You would need to recover it from your backups... you are backing things up, yes?
by chulett
Wed Apr 11, 2007 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Palette is empty
Replies: 5
Views: 3069

Have you tried right-clicking in the pallete, selecting 'Customization...' and then 'Reset to factory defaults'?
by chulett
Wed Apr 11, 2007 12:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: update two tables in a single db2 stage
Replies: 4
Views: 1901

'Transaction grouping' is a little different concept. Use it when each 'group' of records across related tables must all either be committed or rolled back together - on a row by row basis. DSGuru, I'm imposing some constraints on the first link and i want the same to be applied while updating the s...
by chulett
Wed Apr 11, 2007 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: prerequisite while Changing 32-bit To 64-bit Hashed File?
Replies: 4
Views: 1045

Bad Idea. If that's something a search here turned up, it should have also revealed many caveats for enabling that option. You have now made every hashed file 64bit. All of them - in your Projects, in the DSEngine, everywhere. You should change individual hashed files and only the ones that need it.
by chulett
Wed Apr 11, 2007 6:35 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to read PIPE delimited files in PS
Replies: 1
Views: 2512

I would think you would specificy 'Character' and then the pipe as the character in question.
by chulett
Wed Apr 11, 2007 6:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timed out while waiting for an event
Replies: 7
Views: 6843

theverma wrote:Can we increase the number of jobs that can be run simultaneously.

Short answer - no. There's no magic config change that will solve your problem. You need to address the issue of number of simultaneous running/starting jobs as noted.