Search found 46 matches

by Chuah
Thu Jul 27, 2006 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Solaris 8 to Solaris 10 migration
Replies: 1
Views: 717

Solaris 8 to Solaris 10 migration

I am planning to migrate from a server with Solaris 8 and DS 7.5.1. The DS 7.5.1 is currently installed in a server with Solaris 8 and we need to port it to another server with Solaris 10 and decommission the existing server. Question : Can we just copy the entire DS installation and all its files i...
by Chuah
Wed Jul 19, 2006 10:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: As400 ODBC Problem
Replies: 28
Views: 25015

SUN OS bind20 for DB2 failed

Hi,
On my Solaris server (running Solaris 8), when I try to bind20 I got the error

Package Creation Failed : 7742

I can't find that msg in the LC_MESSAGES. Anyone has any ideas what this 7742 code means ?

Chin
by Chuah
Wed Jul 05, 2006 9:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Selective Command Line Export?
Replies: 32
Views: 16919

kaps wrote:DSExport command can also export individual jobs.

Thanks
Hi,
Can DSExport export only Table Definitions without exporting the jobs etc ? What I'm trying to do is export all my Table Def into an XML document.
Pls advise.

Rgds
Chin
by Chuah
Wed Jul 05, 2006 9:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dscmdexport options for XML export
Replies: 1
Views: 1061

dscmdexport options for XML export

Hi,

In the command line export program (dscmdexport) is it possible to export as XML like in the regular program in DS Manager ?
Also is is possible to export only categories ? Please advise.

Thanks
Chin
by Chuah
Sun Jun 25, 2006 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: performance issue
Replies: 7
Views: 1788

Re: performance issue

Hi all, I am running a job which extratcs data from one Oracle database passes trough a transform and loads into another oracle DB. Last week it ran at 100 rows/sec now its running at lessthan 1 row/sec. We tested the sql code on oracle DB its running fine. It seems their is some problem with datas...
by Chuah
Sun Jun 25, 2006 8:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance in Extraction
Replies: 12
Views: 3430

Re: Performance in Extraction

Hi, I have a very simply ds job. It has one Oracle stage and one Sequential file stage. I was trying to extract records from Oracle server and write to sequential file, since there is no transformation needed, I omitted the transform stage. The problem I am getting is that when I ran the query on O...
by Chuah
Sun Jun 25, 2006 8:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Microsoft ODBC for Oracle. BCI Error.
Replies: 6
Views: 2499

Why not use the Oracle ODBC if that works ? You might want to try to reinstall your MS ODBC drivers.
by Chuah
Tue Jun 20, 2006 5:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Email as input
Replies: 2
Views: 1276

Hi, If you're using Lotus Notes ,you can write a Notes macro (Agent) to detach the file and save it to your Notes server.Then you can use the ftp stage in DS to pick up the file. If your data is in an email attachment,same thing you need to write a script to detach the file and save it. You will als...
by Chuah
Mon Jun 19, 2006 11:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Detect change in copybook metadata
Replies: 5
Views: 2219

Currently no. The "diff" tool you request is in the next ("Hawk") release. But it's not automatic - you have to ask for a comparison to be made. ... Thanks Ray.Is there a way to query the Universe database once the copybook has been imported? The approach that I'm thinking of is...
by Chuah
Mon Jun 19, 2006 5:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Detect change in copybook metadata
Replies: 5
Views: 2219

Detect change in copybook metadata

Hi, in DS Manager,I can import a copybook into the DS repository which is fine. Now if the source metadata has changed for this filegroup, is there a way to automatically detect this change when the copybook is imported into DS ? Has anyone done anything similar to detect changes in their copybooks?...
by Chuah
Thu Jun 08, 2006 6:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture rest of records other than the max
Replies: 1
Views: 863

How to capture rest of records other than the max

Hi, I have a requirement to split a dataset into two sets, one set that has records with the max(effective_date) and the other are the rest of the records that are not ones with the max(effective_date). With the Aggregator it is easy enough to get the first file but what is a good technique or stage...
by Chuah
Sun Jun 04, 2006 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel for Windows ?
Replies: 3
Views: 1229

Yes, but it must be version 7.5x2, which is the only version that has job compilation and execution capability for the Windows platform. With other versions you may be able to create parallel jobs, b ... Thanks Ray! One last question ,can a sequencer run a mix of server and parallel jobs in the sam...
by Chuah
Sun Jun 04, 2006 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel for Windows ?
Replies: 3
Views: 1229

Parallel for Windows ?

Hi,
I'm new to the Enterprise Edition so pls pardon this newbie type question.Can parallel jobs run in a Windows server if we install the Enterprise Edition in that server ?

Thanks.
by Chuah
Sun May 28, 2006 8:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cobol data file
Replies: 13
Views: 3949

thurmy34 wrote:Hi,

Does anyone interested by a new version of the SwitchEBCDICSign routine ?
Hi,
Yes would be most interested. Can you please send the routine to jnguy@bigpond.net.au

Thanks,
Nick
by Chuah
Sun May 28, 2006 8:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mainframe MVS File to SF/CFF stage. Values Incorrect
Replies: 4
Views: 4187

Hi,
I'm quite interested in whether you have managed to solve this problem you had ? If so what did you have to do in DS to address this ?
I'll be starting work on a similar sort of project to extract from mainframe to DB2.
Thanks in advance.

Nick