DSXchange

sirisha wrote:Thanks Michael .We approached our DBA and it worked .

Hi

you are welcome!
Could you please mark the topic resolved

Thanks

Rregards
Michael

tfpCustIp,0: DB2 get row partitioning data Error. tfpCustIp,0: SQLCODE = -6039; SQLSTATE= tfpCustIp,0: SQL6039N Partitioning column "0" is currently defined as not nullable. tfpCustIp,0: DB2 Get Row Partitioning Information failed. tfpCustIp,0: Failure during execution of operator logic. ...

Hi as Arnd already stated this is a security issue. You can easily check DB2 error message by searching it in goolge or from the DB2 command line with db2 ? <errorcode> like db2 ? SQL0551. There is a separte database priviledge for load in DB2. You have to be granted the load right before you use it...

Could you please suggest the best way to implement this logic in datastage? Are Routines, SQL Procedures or Unix scripting the best option or is there some other easy way? Thanks a lot for your help. Hi, you are looking for an easy way - well this depends.... I think it is important to split your p...

Anyone every try to issue a runstats command as an after SQL? Hi, yes! :-) The problem is you want to specify a AFTER SQL and runstats is a DB2 command and not SQL! This is why it will not work the way you tried it. But you can do it using a nice little stored procedure DB2 provides since version 9...

Hmm. That's a new one. MQ sites say that it has something to do with a parameter called EXTSH (or similar). Haven't seen it, but a few of the MQ sites I was browsing seem to imply that it existed in prior releases....did they make any changes to the queue manager configuration? Ernie Hi Ernie, well...

Hi,

the MQ guys upgraded the MQ version installed on our AIX server from version 6 to version 7.
We are experiencing following connection errors: Any ideas?
Has anyone a running system with DS 7.5.3. and MQ 7?

Thanks in advance
Michael

Hi All, We are having issues for the below job flow. We created a dataset which contains the Store_id,Run_date and P_Id. This needs to be passed to the next sql statement in an iterative way. i.e: we have around 40000 store_id,P_Id. Eg: SELECT 1,2,3,4 from Table WHERE Id in (<Store_id>, <P_ID>) AND...

chulett wrote:Have you involved your official support provider yet?

Hi chulett,

not yet - I have another support case running for 2 month now...
It is sometimes quicker to find an alternative solution

I thought the best way to get some background is here....

kind regards
Michael

No idea. Bummer. You may have to resort to something else, like trying an update to that server, or a custom sql that issues a command that will provide at least some kind of return code.....of course, checking that return code could be difficult (this would be much simpler in Server). Ernie Hi, we...

I think the lookup is the simplest, and also the most consistent (it's doing exactly what your "real" lookup is doing), but perhaps there are other ways to more easily detect that the database is up and available. Ernie Hi Ernie, that is what I tried to implement - until I stepped over an...

Hi Ernie, I've seen this before. Too bad the job doesn't abort. One solution is to lengthen the timeout from your rdbms, and another is to make adjustments to the maximum runtime, so that the job recycles more often. I do not see the point what any timeout could do. Waiting is no solution in my eyes...

Hi, I have a always on WebService running which selects result rows from a DB2 table via an ODBC stage. The ODBC stage is used because I need a multi-row lookup. So far so good. If the ODBC connection terminates unexpectantly - i.e. through a force command or database shutdown etc. the WebService do...

Hi chulett, I use DB2 own tools like Command Editor most of the time but it is not longer strategic - even deprecated. IBM suggests DataStudio (eclipse) which is free (there are also OPTIM tools which are not free but based on the same plattform) and has some neat features. A very nice non-IBM tool ...

eostic wrote:Can I assume that you are including both Xmx and Xms at the same time? One is for initial size and the other is for max....

Ernie

Hi Ernie,

we actually tested both - with just -Xmx210M and with -Xms100M -Xmx210M
both failed with Xmx210M and both run with Xmx200M

crazy stuff

regards
Michael