DSXchange

DataStage sequences are of "server job" type, not parallel...in case that you don't have parallel jobs in that sequence

What's the value for the APT_CONFIG_FILE environment value? Are you including the that environment variable as a parameter in your sequence?

Hi Kelly, "Divide and conquer" will be the best approach on the cases that are failing. Try to parse the XML input file that is failing without applying the XSLT step, just output the content of your XML into another XML file. If it fail then you have the root cause. Just make a copy of yo...

If the web service works outside of the DataStage environment, then take a look at APAR JR45664 For a client-side patch for Fatal error 0026 related to incomplete results table definitions when importing WSDL file Also you could try to define the table definitions manually, best practice is to impor...

Hi qt_ky,

Check this Tech Note, might help to mitigate the issue, specially if your servers are behind a firewall:

http://www-01.ibm.com/support/docview.w ... wg21979949

Regards

Hi qt_ky,

Check this Tech Note, might help to mitigate the issue, specially if your servers are behind a firewall:

http://www-01.ibm.com/support/docview.w ... wg21979949

Regards

Yes, you are right on the spot...add the artificial keys upstream for each list that would be used in the regroup steps, when doing the join... This is by design, in case you work with multiple independent sources "List" as input you would need to rely on the key within each list to be abl...

Andy, Since your parameter set contain only environment variables set to $PROJDEF try without passing -mode to the dsjob command for both regular run and restart. Please notice that the DataStage job sequence, if configured to be restart-able, will always start from the failure point ... and you, I ...

We skipped version 9.1 all together but you should be able to delete published data quality rules with the IAAdmin.sh command with option -deletePublicRule /opt/IBM/InformationServer/ASBServer/bin/IAAdmin -user admin -password admin -url https://myhost:9443 -deletePublicRule -projectName project_nam...

Hello Sandeep, You could included any number of records with both XML stages, but your real constraint will be the consumer web service. Will it be able to process a massive XML file? Will the number of records in the source database increased over time? The design of the process should be able to s...

The most common cause for DataStage jobs to get locked is leaving them open or force them to terminate, but your issue is in production environment where you wouldn't need to compile your jobs unless is your standard practice What's the topology of your ISD job? I would guess that it executes the DS...

...try below from same location ./xmetaAdmin.sh cleanupAbandonedLocks -dbfile ../conf/database.properties Notice that you could also list and kill all user and trusted active sessions, including the sessions that are not visible from the web console, using the SessioAdmin.sh utility from same direct...

...and you have the current month, right? Then it will be a matter of date arithmetic. Resolved the first day of the current month and substract 1 day to it. OConv(Iconv(CurrMonth:"01" ,"D YMD[4,2,2]") - 1), "D YM[4,2]") I would suggest to do this in a user variable and...

Did the admin team try to clear the locks with the cleanup_abandoned_locks.sh utility from /opt/IBM/InformationServer/ASBServer/bin? This might help specially if they can not see an active session in the webconsole or via the traditional Unix commands

The IBM install/Updater scripts are not able to authenticate dsadm account against LDAP -I submitted a PMR inquiring about this - but as PaulVL stated you could create the dsadm and dstage group in your LDAP registry and then used the UID/GID values to create the local counter parts for installation...

The DataStage job will have visibility to local directories only...I'm afraid that you would need to mount the directory to the DS server and open up the permission to the user executing the DS jobs. If by shared you meant mounted directory then check the permissions on the "shared" direct...