Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    27

    Unanswered: Getting "BandP not pushed down" while running a query

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Upgrade to the latest 8.2 fixpack. The fixpack upgrade can be downloaded free of charge.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2007
    Posts
    27
    Quote Originally Posted by Marcus_A View Post
    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?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by debayan View Post
    Upgrading DB2 is our long term goal. Is there any short term fix for this?
    Make the fixpak installation your short-term goal.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If you search for sql0901n and bandp on google, you'll find APAR IY65288. You could be running into this one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •