DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 513 matches
Author Message
Resolved
 Topic: All users (including Admin) cannot open client session.
rkashyap

Replies: 4
Views: 165

PostForum: General   Posted: Mon Mar 26, 2018 12:34 pm   Subject: All users (including Admin) cannot open client session.
Thank you. Apparently, lots of zombie DataStage connections were being created from a rogue DataStage session on a desktop and maximum no of sessions was exhausted, thus no new session could be opened ...
Resolved
 Topic: All users (including Admin) cannot open client session.
rkashyap

Replies: 4
Views: 165

PostForum: General   Posted: Sat Mar 24, 2018 8:09 pm   Subject: All users (including Admin) cannot open client session.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 FP1 on RHEL 7; XMETA DB2; LDAP authentication.
Attempts to open Client session for all users including Admin are failing with message:

<Status xmlns="http://iis.ibm.com">
<httpStatus>503</httpStatus>
<msgId& ...
 Topic: Hive Connector Vs ODBC Connector
rkashyap

Replies: 4
Views: 1186

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 05, 2018 4:16 pm   Subject: Hive Connector Vs ODBC Connector
Hive connector leverages JDBC connectivity.

We are using both ODBC Connector and Hive Connector for connect with Hive and have not seen much difference between the performance of the two.
 Topic: JDBC-Connector issues
rkashyap

Replies: 6
Views: 569

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 26, 2018 6:14 pm   Subject: JDBC-Connector issues
You can see the SQL statement performing Delete and subsequent Insert in DataStage Director. Confirm that ALL columns that the connector can be paired with the target table.
 Topic: Install on Remote DB2 with SSL port
rkashyap

Replies: 2
Views: 241

PostForum: General   Posted: Thu Feb 22, 2018 7:07 pm   Subject: Install on Remote DB2 with SSL port
Are you trying to create a connection from DataStage to a DB2 database with SSL?
 Topic: How Pivot Stage works in Server Edition of Datastage 11.5
rkashyap

Replies: 3
Views: 352

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Feb 22, 2018 6:18 pm   Subject: Re: How Pivot Stage works in Server Edition of Datastage 11.
I'm trying to convert multiple rows into one row. I can see the Pivot stage in Processing Palette, but I don't see the properties of Pivot stage other than Input and Output.
Requirement is to perform ...
 Topic: List the sequencers which uses environmental variable
rkashyap

Replies: 2
Views: 220

PostForum: General   Posted: Thu Feb 22, 2018 5:51 pm   Subject: List the sequencers which uses environmental variable
Alternatively, if you are using Operations Console, then you can modify following query to get the desired resultSELECT
H.HostName
, J.ProjectName
, J.JobName
, P.ParamNa ...
 Topic: List the sequencers which uses environmental variable
rkashyap

Replies: 2
Views: 220

PostForum: General   Posted: Thu Feb 22, 2018 5:29 pm   Subject: List the sequencers which uses environmental variable
TryLIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE ...FTP_EPSILON_HOST...
 Topic: JDBC-Connector issues
rkashyap

Replies: 6
Views: 569

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 22, 2018 5:08 pm   Subject: JDBC-Connector issues
What is value of "[url=https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_8.7.0/com.ibm.swg.im.iis.conn.odbc.help.doc/topics/r_codbccon_cn_Drop_unmatched_fields.html]Drop unmatched fields" in the J ...
 Topic: Two Source Match Stage, long running job and fails at last
rkashyap

Replies: 4
Views: 344

PostForum: IBM QualityStage   Posted: Fri Feb 16, 2018 10:21 am   Subject: Two Source Match Stage, long running job and fails at last
Is the job using bounded length varchars in the data? If yes, then setting the [url=https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvr ...
Resolved
 Topic: RCP not working for Salesforce Server Package stage
rkashyap

Replies: 6
Views: 3277

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 16, 2018 10:08 am   Subject: RCP not working for Salesforce Server Package stage
SFDC stage (still) does not supports RCP. You may submit a [url=https://www.ibm.com/developerworks/rfe]Request for Enhancement for this.
Workaround Reported
 Topic: Multiple records based on value in column
rkashyap

Replies: 9
Views: 663

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 16, 2018 9:57 am   Subject: Multiple records based on value in column
Another option could be leveraging Unix ... invoke following command in either External Source stage or using Filter option of Sequential file stage
awk 'BEGIN {FS="|";RS="\n" ...
 Topic: Webinar vNext
rkashyap

Replies: 8
Views: 637

PostForum: General   Posted: Tue Dec 19, 2017 8:09 am   Subject: Re: Webinar vNext
Eric, Thanks.

Does anyone have any updates on when the next version of Information Server will be released?
Per [url=https://www-01.ibm.com/common/ssi/rep_ca/7/649/ENUSA17-0877/ENUSA17-0877.PDF]IB ...
 Topic: Webinar vNext
rkashyap

Replies: 8
Views: 637

PostForum: General   Posted: Thu Dec 14, 2017 5:15 pm   Subject: Webinar vNext
There will also be another webinar next Tuesday. Are you getting the email invitations?
How did you signup for the webinar?
Resolved
 Topic: Balanced Optimizer missing / unavailable
rkashyap

Replies: 11
Views: 1268

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 14, 2017 4:30 pm   Subject: Balanced Optimizer missing / unavailable
Post initial installation, Balanced optimization can be <IS_install_path>/ASBServer/iisAdmin.sh -set -key com.ibm.iis.datastage.license.feature.BAL_OPT -value 1
 

 Jump to:   



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