Search found 149 matches

by raji33
Wed May 30, 2018 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while loading db2
Replies: 7
Views: 4884

we are writing the named pipe files to scratch location as we have more space there.
by raji33
Mon May 28, 2018 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while loading db2
Replies: 7
Views: 4884

yes its the same user.
by raji33
Mon May 21, 2018 4:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while loading db2
Replies: 7
Views: 4884

Re: error while loading db2

Yes. i checked the path and it exists. The user has all the required permissions. If i point the location somewhere else , the job run successfully.
by raji33
Sun May 20, 2018 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while loading db2
Replies: 7
Views: 4884

error while loading db2

Hello, We have a error while doing bulk load to db2 table. Any suggestions please. Error 2 occured from mkfifo while creating named pipe. same job is working fine in other project. Job Design Dataset-------db2udb i checked the space and also looked at permissions everthing looks good. i tried creati...
by raji33
Fri Feb 02, 2018 11:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error connecting to Big SQL
Replies: 2
Views: 3882

Error connecting to Big SQL

Team, We are getting the below error while connecting to Big SQL through DB2 connector. We did catalog and configured isjdbc.config file as well. Any suggestions please? DB2_Connector_0: DB2 function SQLFetch failed: SQLSTATE = 40504: Native Error Code = -1,229: Msg = [IBM][CLI Driver][DB2/LINUXX866...
by raji33
Wed Jan 31, 2018 12:17 pm
Forum: General
Topic: Fix pack install fails with error
Replies: 2
Views: 2261

yes i tried rebooting but the process was automatically starting with even reboot. I checked the process and manually killed it, retriggered the install and it got success.
by raji33
Tue Jan 30, 2018 4:48 pm
Forum: General
Topic: Fix pack install fails with error
Replies: 2
Views: 2261

Fix pack install fails with error

Hi All,

I am facing below error while installing fix pack for 87version on my PC. Any suggestions please?

java.io.FileNotFoundException: xxxx\87\InformationServer\MCM\ClientSwitcherService.exe (The process cannot access the file because it is being used by another process.)

Thanks
by raji33
Fri Sep 08, 2017 11:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL server login issue
Replies: 2
Views: 3166

SQL server login issue

Hi All, We have a situation where we can able to connect to sql server db with generic sql account, But our requirement got changed and now we want to connect the db using windows user as the access to database is controlled by AD group. We can able to connect through sql tool using same windows use...
by raji33
Fri Sep 08, 2017 11:42 am
Forum: General
Topic: List of jobs uses a specific parameter
Replies: 4
Views: 3932

Thanks Chulett. Its working.
by raji33
Thu Sep 07, 2017 10:58 am
Forum: General
Topic: List of jobs uses a specific parameter
Replies: 4
Views: 3932

List of jobs uses a specific parameter

Hi All, I have a requirement where i need capture the list of the jobs where a specific parameter is being used. Query i am using LIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE ...ABC... Where ABC is my parameter. My issue is, I am getti...
by raji33
Tue Mar 14, 2017 9:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Netezza data issue
Replies: 0
Views: 2058

Netezza data issue

Hi, We are seeing issue while reading and writing into netezza database. datatype is double precision in source and target and the db is netezza. Issue: We are using RCP, data is getting rounded off to (precision 1) and the value at the second place(precision 2) is being truncated while reading from...
by raji33
Fri Feb 17, 2017 6:03 am
Forum: General
Topic: Datastage configuration
Replies: 3
Views: 2375

Datastage configuration

Hi, We have a situation where job went through fine in qa but was having issues in prod.so want to comare high level datastage limitations/settings/ configuration from datastage standpoint on server across all environments dev/sit/qa and prod to make sure there are no differences. Firstly what i can...
by raji33
Sun Jan 15, 2017 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuring WebService stage in datastage
Replies: 1
Views: 2163

Configuring WebService stage in datastage

Hi All,

We have a requirement to integrate webservices in datastage, for which we received the certificates from the host owner. May i know in which path we need to install those certificates on server. Any suggestions please?

Thanks
by raji33
Mon Dec 05, 2016 12:25 pm
Forum: General
Topic: WebSphere Administration Server: script execution failed
Replies: 2
Views: 2983

/root was 100% occupied, once the space got cleared everything went fine.
by raji33
Sat Dec 03, 2016 11:23 pm
Forum: General
Topic: WebSphere Administration Server: script execution failed
Replies: 2
Views: 2983

WebSphere Administration Server: script execution failed

Hi, I am seeing below error while starting WAS. Any suggestions please? runConfigActions script execution failed. Exit code: 1 Exception caught while waiting for runConfigActions script to complete: /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/bin/runConfigActions.sh Thanks [Note - topic changed...