Getting "BandP not pushed down" while running a query

debayan · #1 (**permalink**) 02-11-11, 10:00

Hi all,

I am currently using DB2 V8.2 (fixpack 7) on Solaris. I am trying to run the following query:

Code:

SELECT B.ID, C.LOCATION, A.SYSID, A.OPTIONS 
FROM PRISM.OPTIONS A, ACTIVITY.MASTER B, CONTROL.LOCATIONS C 
WHERE A.SYSIS = B.SYSID AND B.ID = C.ID
AND C.location = '011';

I got the following error:

SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "BandP not pushed down ".)

Explanation:

An error has occurred which is due to a system error. Processing
of the SQL statement has ended for reason "<reason>" (this is in
English only and is useful only to IBM support personnel).

sqlcode : -901

sqlstate : 58004

Now if I run the same query for a different location, the query completes successfully:

Code:

SELECT B.ID, C.LOCATION, A.SYSID, A.OPTIONS 
FROM PRISM.OPTIONS A, ACTIVITY.MASTER B, CONTROL.LOCATIONS C 
WHERE A.SYSIS = B.SYSID AND B.ID = C.ID
AND C.location = 'B25';

I am not sure what is causing this error. Any help is greatly appreciated.

Thanks in advance,
Dave

Marcus_A · #2 (**permalink**) 02-11-11, 10:27

Upgrade to the latest 8.2 fixpack. The fixpack upgrade can be downloaded free of charge.

debayan · #3 (**permalink**) 02-11-11, 11:01

Quote:

Originally Posted by Marcus_A

Upgrade to the latest 8.2 fixpack. The fixpack upgrade can be downloaded free of charge.

Thanks Marcus. Upgrading DB2 is our long term goal. Is there any short term fix for this?

n_i · #4 (**permalink**) 02-11-11, 11:06

Quote:

Originally Posted by debayan

Upgrading DB2 is our long term goal. Is there any short term fix for this?

Make the fixpak installation your short-term goal.

db2girl · #5 (**permalink**) 02-11-11, 12:15

If you search for sql0901n and bandp on google, you'll find APAR IY65288. You could be running into this one.

Internet Services

Web Development

Digital Marketing

Consumer Tech