DSXchange

No need to do both indeed. I will go for the delete statement if there's no difference then :) I think the previous developer just got a bit confused. Probably selected the delete method but at the "Table action" step he had to chose something, so preferred "truncate" over "...

Hi, I have a job with an Oracle stage, that is just used to empty a table: http://i.imgur.com/lbq4TdN.jpg As you can see, we ask DataStage to run a truncate statement first then a delete * statement on the same table. But from time to time, the delete statement is executed before the truncate statem...

Hi, Shiva, I have the exact same problem as you. Renewed premium membership on 28/04/2016 but I am still not a premium member... Sent a first e-mail with Paypal transaction details on 30/05/2016 to membership.director@dsxchange.com then a second one on 26/06/2016 to both membership.director@dsxchang...

JR50332: EngMonApp stops running when using Oracle server version 11.2.0.4.

This fix is for your version of Oracle.
Anyway, support will confirm if it is the right one for you or not.

Ok.
If you do involve support in the future, remind them that your issue seems to be the same as what is described for JR50332:
http://www-01.ibm.com/support/docview.w ... wg1JR50332

Hi Tony. What is your version of Oracle ? I am not able to start the engmonapp service for the exact same reason as you: http://www.dsxchange.com/viewtopic.php?t=155555 I am going to move DSODB to db2 on the XMETA database. I wasn't able to have a fix for this issue from support. It looks like you c...

Personally, I would not like to have to develop in an environment with just one node. If you have not used the correct partition, you may have the intended result in that one node environment (as everything is processed sequentially) but you will only notice your mistake once you've delivered your j...

If you are using the Enterprise edition of DataStage, the Pivot Stage could help you there.

Pivot type: horizontal
Group by: ID
Pivot on: Sev 1, Sev2, Sev3

Or it might be the other way around, haven't used it for a while
have fun

Thank you qt_ky.
I guess we don't have much options left, apart from upgrading to 11.x, not even 2 years after upgrading to 9.1

I have received a response from the support: The same supported databases apply for DSODB as XMETA so Oracle 12c is not supported for datastage 9.1 Doesn't sound like we can have the patch made for 11.3 and 11.5 for that precise issue for our 9.1 version :/ Also, as we have XMETA on the default IBM ...

Hi, Our DSODB database for the Operations Console has been migrated from Oracle 11g to 12c and I now have the following error when I try to start the EngMonApp: [IBM][Oracle JDBC Driver]Value can not be converted to requested type This is a known issue: http://www-01.ibm.com/support/docview.wss?rs=1...

After trying 1 billion different URL syntaxes, I gave up and used the following work-around: I kept the my original URL syntax: jdbc:ibm:oracle://NZWLGTGENDBRH1:1521;SID=TGEN1PDB And asked the Oracle DBA to add the following to the listener.ora file: USE_SID_AS_SERVICE_listener=on where listener is ...

Hi, We have recently migrated our DSODB database from Oracle 11g to an Oracle 12c pluggable database. I have unregistered then re-registered everything to point to the new DB, but I still have a problem which, it seems, has to do with the JDBC URL format I am using: I did the following test: ./DSApp...

Hello, -My source and target database is going to be moved from Oracle 11gR2 to 12c (XMeta Repository will stay on 11g) - I am only using the Oracle Connector stage in my DataStage 9.1 project 1) Would I be correct in assuming that I (hopefully) shouldn't need to do anything: - I can keep the Oracle...

Hi

yes, please keep us updated please

Also FYI, it says in this IBM doc that the Oracle Bulk Load plugin is not supported:
http://www-01.ibm.com/support/docview.w ... wg21683476