CODEWITHSUNDEEP
db2ibm-midrangedb2-400
Renier
Renier

Reputation: 1830

DB2 Internal failure occurred in query processor

We have two as400's both V6R1M0 One is our Development and the other Production.

Please note I do not know the as400 that well.

I created a test webpage running from IIS to recreate the scenario.

The page has a button that creates a connection to db2 database and I do a select from a few tables with SQL and populate a grid with the data.

This works fine in DEV but when I run the same site but pointing it to our Production environment it fails with an error code SQL0901 SQL system error.

Note : I did check the SQL and the query itself is working in both environments.

On the green screen When I check The joblog of the page I get the following error: enter image description here

Next I Checked google on the error and It seems like a PTF that needs to be installed in Production.(I do not know witch one). It has something to do with db2.

The problem that we have is that There are also other systems running on our Production environment and I am scared that when installing a PTF that it will cause issues...

How do I know what PTF to install by comparing DEV and Production? Is there software to do the comparing? Ideally I would only like to install the PTF that is in DEV but not in PRD.. Once again I dont know witch PTF will fix my issue.

Any help will be appreciated.

Added:

On the green screen when I press F1 on the error(QQQVECI: Did not find external field!!!.) I get the following:

enter image description here

When I then Press F9 to view details I get the following:

enter image description here

Upvotes: 0

Views: 684

Answers (3)

Korinne Adler
Korinne Adler

Reputation: 676

I agree with other answers about the likely PTF, but to answer your question

How do I know what PTF to install by comparing DEV and Production? Is there software to do the comparing?

IBM recently enhanced the IBM Application Runtime Expert product to help with just this problem. The new PTF support in ARE is able to compare the system PTF levels against:

In addition, it's able to automatically apply the missing PTFs on the target system if you want.

See this blog for more information on how to take advantage of the support.

Upvotes: 0

user2338816
user2338816

Reputation: 2163

Hard to be sure, but the general PTF you might be missing should be SI47445. Unfortunately, that was superseded a couple years ago by PTF SI47911. And that was later superseded by PTF SI50956. And each of those has pre-req and co-req PTFs.

As @Charles mentions, your admins will be closely involved. It's quite possible that nothing can be done for some time until some downtime can be scheduled for maintenance.

PTF SI47445 was part of PTF cume package 2305, a general collection of fixes available at the beginning of November 2012. At least one additional cume package was released for IBM i 6.1 in 2013, and some unknown number of individual PTFs since. The potential number of differences in PTFs between a system that is missing a cume package from as far back as 2012 and a more current system is possibly in the hundreds of PTFs.

Even your admins are likely to resist trying to figure the right way to get a single PTF applied.

A possible generally appropriate plan would have been to apply cume package 2305 on your DEV system in early January 2013. That would give a couple months for various early-adopter sites around the country (or world) to report problems with it and for IBM to correct them. Then, if DEV seemed okay, your PROD system could get the same cume package a month later, in early February 2013. (A few group PTF packages should go along with cume packages.)

But that plan is apparently moot.

Now, a more likely plan would involve (1) noting what cume and group packages are on DEV, and (2) determining if the media for each of those is still available to your admins for use on PROD.

If the media is no longer available, a somewhat different plan would need to be considered.

Upvotes: 3

Charles
Charles

Reputation: 23783

You need to get your IBM i admins involved.

Internal failure occurred in query processor is certainly indicative of a bug in the OS that's needs to be/or has been corrected by IBM.

Your admins, possibly with IBM's help, can determine if there's an existing PTF to correct whatever is causing the error.

Your admins can then download and apply the PTF.

It is unlikely you would be able to download the PTF, let alone have the authority to apply it in production.

Upvotes: 2

Related Questions