DSXchange

Perhaps DB2 privileges are different? Either way, you could also do additional testing to narrow it down, such as carefully testing a test job against a prod database, and/or carefully testing a prod job against a test database.

Doesn't the job activity stage wait for each job to complete, whereas the dsjob -run command has a -nowait option?

Another 11.3.x surprise we found was related to the Workload Management feature, or WLM. Others may have run across in 9.1.x, which we skipped... In our first pass at setting up an 11.3 server, we had a minimal amount of physical memory, although it may have been more than the minimum recommended. T...

The g++ reference was mistakenly misleading, and they did correct it on the system requirements site soon after we pointed it out.

I saw an IBM bulletin yesterday that indicated that Fix Pack 1 for 11.3.1 (= version 11.3.1.1) results in a problem in the Operations Console (JR52899). Here is a link.

https://www-304.ibm.com/support/entdocv ... wg1JR52899

Start by reviewing this topic: http://www.dsxchange.com/viewtopic.php?t=153699&highlight=surprise The IBM Concierge service is no more. They used to help customers with such migrations. Their migration utility is no longer supported either. There is a migration document, and corresponding sectio...

An alternative outside of DataStage would be to request a network person to monitor inbound and outbound network traffic with your DataStage server over an average 24 hour period and send you a report with the number of bytes for each. There are probably operating system commands that would let you ...

Support confirmed with engineering that there is no command line method available (at least nobody knows of one)... So I have entered an Enhancement Request. Please review this enhancement request and VOTE using the RFE link below with your IBM ID. Here is the write-up: 1. Enhance the dsadmin comman...

Please review this enhancement request and VOTE using the RFE link below with your IBM ID. I had a PMR on this topic and was told it is working as designed, therefore it is not a defect. Tell that to your glossary authors! :? Here is the write-up: Avoid accidental loss of data when creating new asse...

What you described as a workaround is the only solution I am aware of. I don't consider it to be a workaround. I believe it is meant to work that way. I would be happy to learn otherwise. On a similar subject, have you tried using the newer DataDirect SQL Server Native Wire Protocol driver (VMsqls00...

Bytes moved by a job will vary wildly with each different job design and could be meaningless (i.e. Job 1 moved 1GB from stage A to stage B and 900 MB from stage B to stage C and 900 from C to D, etc.). Bytes moved across each link may be a useful measurement, but I do not know of an environment var...

Also keep in mind that negative numbers will lead with a negative sign, not a space...

Try searching on "parallel job reports failure (code 139)" and go through the results.

I encountered different but similar smelling problems on 11.3.x that turned out to be caused by using a slightly different compiler than exactly the version listed on the system requirements web site. A newer version caused problems, and the same version with patches (PTF's) applied also caused stra...

Everything under the /IIS/IBM/InformationServer/Repos/xmeta structure is part of the XMETA repository database. Those files are managed by DB2. Do not delete any of those files. I would suggest searching the IBM Support Portal or contacting Support to ask the same question as well--how to safely red...