DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 523 matches
Author Message
Resolved
 Topic: Copy Stage as the end Stage
ag_ram

Replies: 2
Views: 1936

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 17, 2009 10:48 am   Subject: Copy Stage as the end Stage
Thank you very much Ray!!

Regards,
Resolved
 Topic: Copy Stage as the end Stage
ag_ram

Replies: 2
Views: 1936

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 16, 2009 6:03 pm   Subject: Copy Stage as the end Stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hello,

I have a strange scenario, where we have a copy stage as the end stage.

Could you please tell me, if there would be a problem like records being held in the memory. or any possible memory ...
 Topic: put message to websphere MQ connector
ag_ram

Replies: 1
Views: 1324

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 09, 2009 7:56 am   Subject: put message to websphere MQ connector
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: mq limit design consideration
hi,

i have following scenario:

database----extract---File
File---Put---- MQ

All the data put to queue as single message, by configuring sequential file.

here the queue has limit of 4 mb, ...
 Topic: Update not working
ag_ram

Replies: 5
Views: 1953

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 17, 2009 12:43 am   Subject: Update not working
DataStage® Release: 7x
Job Type: Server
OS: Windows
Hi All,

I have a following job design
sequential file -- transformer - Oracle enterprise stage.

I need to update the table incase of matching key columns otherwise i need to insert a new row.
...
 Topic: Issue in connecting to database through SQLplus
ag_ram

Replies: 2
Views: 3574

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 13, 2009 4:52 pm   Subject: Issue in connecting to database through SQLplus
Hi,

I am using a exec command stage in sequencer to call a shellscript.
please see syntax below used inside the script.
$ORACLE_HOME/bin/sqlplus -s $1/$2@$3 <<eof
$1 – DB user id, $2 – pas ...
 Topic: Issue in connecting to database through SQLplus
ag_ram

Replies: 2
Views: 3574

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 12, 2009 6:34 pm   Subject: Issue in connecting to database through SQLplus
DataStage® Release: 7x
Job Type: Server
OS: Unix
Hi All

I have an issue connecting to oracle database through SQLPLUS.
Datastage is installed in one server and Oracle database is in another server.
I have updated TNSNAMES.ORA file with connect ...
 Topic: Commit Frequency of a Stored Procedure Stage
ag_ram

Replies: 1
Views: 1481

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 15, 2009 1:27 am   Subject: Commit Frequency of a Stored Procedure Stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi ,

I am executing a stored procedure by passing parameters from a dataset file.No COMMIT statements are given in the stored procedure. Intention is to rollback all records processed by this job i ...
 Topic: Migration of code from 7.1 to 7.5.1
ag_ram

Replies: 3
Views: 2071

PostForum: General   Posted: Wed May 27, 2009 7:47 am   Subject: Re: Migration of code from 7.1 to 7.5.1
Will thr be any change in the data formats(date) if a code is mgrated from DS 7.1 to DS 7.5.1, as 7.1 doesn't support NLS

The difference in the dsx(for same code) taken from 7.1 and 7.5.1 servers w ...
 Topic: Migration of code from 7.1 to 7.5.1
ag_ram

Replies: 3
Views: 2071

PostForum: General   Posted: Thu May 21, 2009 12:18 am   Subject: Migration of code from 7.1 to 7.5.1
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Will thr be any change in the data formats(date) if a code is mgrated from DS 7.1 to DS 7.5.1, as 7.1 doesn't support NLS
Resolved
 Topic: Invoke JCL through Datastage
ag_ram

Replies: 8
Views: 6288

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 21, 2009 12:12 am   Subject: Invoke JCL through Datastage
Thanks Ray!
Resolved
 Topic: Invoke JCL through Datastage
ag_ram

Replies: 8
Views: 6288

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 20, 2009 10:24 pm   Subject: Invoke JCL through Datastage
DataStage® Release: 7x
Job Type: Server
OS: Windows
Hi,

I am using Datastage EE v8.0.1 on AIX. Can you please let me know if we can invoke a JCL through datastage job, sequencer or UNIX script.

Thanks.
 Topic: Archive job design suggestion
ag_ram

Replies: 1
Views: 1589

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun May 10, 2009 9:56 pm   Subject: Archive job design suggestion
DataStage® Release: 7x
Job Type: Server
OS: Windows
Additional info: DRS stage
hi,

I have a series of server jobs
DRS stage ------ Transformer---- Sequential file

the number would be 33 similar jobs like above with different tables.

These job are being called using set ...
 Topic: Error 80040154 Unable to initialize datastage compiler
ag_ram

Replies: 1
Views: 2225

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat May 09, 2009 5:05 am   Subject: Error 80040154 Unable to initialize datastage compiler
DataStage® Release: 7x
Job Type: Server
OS: Windows
Hi ,

I have created a batch file to compile a job in unix server.

Below commands are used in the batch file for accessing dscc utility.

cd D:\Program Files\Ascential\DataStage7.5.1

dscc /h ...
Resolved
 Topic: kicking off multiple instances in one dsjob command
ag_ram

Replies: 4
Views: 2321

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Apr 28, 2009 7:35 pm   Subject: kicking off multiple instances in one dsjob command
Thats correct. It is always better to check the status of the instnace in the loop.

Thanks Ray.
Resolved
 Topic: kicking off multiple instances in one dsjob command
ag_ram

Replies: 4
Views: 2321

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Apr 28, 2009 11:38 am   Subject: kicking off multiple instances in one dsjob command
For answer 2:
Can I use ps -ef | grep "jobname" to find out the presence of process in unix server?
If I dont find anything, I will pass the control back to job invoker. This wait and check will co ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours