Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Unanswered: Weird error on DROP TABLE

    9.1 fp4a on AIX

    I'm getting a really weird error on a drop table command for one specific table:

    SQL0901N The SQL statement failed because of a non-severe system error.
    Subsequent SQL statements can be processed. (Reason "Dependent MST's packed
    Descriptor not found".) SQLSTATE=58004


    I get the same for a drop tablespace where the table resides. Finding it really hard to find any pertinent info on the error message... any ideas?

    Background: I've dropped all other tables, views, etc etc. in oder to do a clean refresh of all the objects....

    EDIT:
    oh yea the diaglog has this:

    2010-03-29-17.55.16.097980+660 I8579944A688 LEVEL: Severe
    PID : 3354730 TID : 1 PROC : db2agent (MDB) 0
    INSTANCE: db2inst4 NODE : 000 DB : MDB
    APPHDL : 0-7 APPID: *LOCAL.db2inst4.100329065300
    AUTHID : DB2INST4
    FUNCTION: DB2 UDB, catalog services, sqlrl_drop_all_tables_in, probe:2380
    CALLED : DB2 UDB, catalog services, sqlrl_drop_table
    RETCODE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
    "unexpected error but state is OK"
    MESSAGE : Failed to drop table unexpectedly


    BADNEWS error??!!?! No s#%t :P
    Last edited by meehange; 03-29-10 at 04:26.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    A -901 (SQL0901) error usually means that you hit a DB2-internal problem. You'll have to open a PMR with IBM support to get this fixed.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Just a wild guess, but I would say this error is bad news:

    ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  5. #5
    Join Date
    Jul 2004
    Posts
    306
    I think you're right!
    We do have view optimization turned on AND one of the devs dropped a column on that table!

    Unfortunately I was on a deadline and so I had to restore a backup and redo the drops, which worked... but it's good to get a real explanation (and fixpack info), THANKS!

Posting Permissions

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