Error: SQL0805N when attempting to drop a package

[tmillett]

Need to drop a set of packages from a Db2 v8 fp8 database on AIX. When attempting the drop package command, I'm getting a -805 sqlcode. I've tried the drop command with the version specified and without. I was able to see the version id in the DB2 Control Center and it is a timestamp, which I'm assuming is the consistency token. The packages were created via remote bind from a z/OS server.

We are trying to delete the packages because a second bind was inadvertently done against the database and we were getting a -804 sqlcode. If there is a way to fix the -804 without dropping the packages, please let me know that also.

I have been able to delete some of the packages, so at this time, we wanted to just clean everything up and start over.

Here's what I'm seeing:

option 1:
> db2 "drop package DPR_CFMBMS.ASNDBCON "
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0805N Package "DPR_CFMBMS.ASNDBCON" was not found. SQLSTATE=51002

option 2:
> db2 "drop package DPR_CFMBMS.ASNDBCON version 2005-10-05-21.48.24.996498"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "drop package DPR_CFMBMS.ASNDBCON version" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>". SQLSTATE=42601