It changed my original email:
db2 connect to DBALIAS user USERID using PASSWORD
db2 bind path$ddcsmvs.lst blocking all sqlerror continue messages
ddcsmvs.msg grant public db2 connect reset
The ddcsmvs.lst has the package bind in that list among a bunch of
others. Change the $ to the at sign.
Another way to do this is to launch the DB2 Configuration Assistant
(db2cca). Highlight the database that needs the bind and click on BIND.
You will need to bind the utilities when it gives you the selection
list.
Wayne Stevens
-----Original Message-----
From: Stevens Wayne
[mailto:db2udbdba-ezmlmshield-x78566820.[Email address protected]
Sent: Monday, November 19, 2007 1:56 PM
To: LazyDBA Discussion
Subject: RE: SQL0805N Package 'NULLID.SQLC2E06 0X4141414141634555' was
not found
db2 connect to DBALIAS user USERID using PASSWORD
db2 bind [Email address protected] blocking all sqlerror continue
messages
dcsmvs.msg grant public
db2 connect reset
Wayne Stevens
Wayne.[Email address protected]
-----Original Message-----
From: pavan
[mailto:db2udbdba-ezmlmshield-x10308644.[Email address protected]
Sent: Monday, November 19, 2007 1:44 PM
To: LazyDBA Discussion
Subject: RE: SQL0805N Package 'NULLID.SQLC2E06 0X4141414141634555' was
not found
Thanks Wayne.
This is a DB2 V8.2 on AIX 5.3
I do not find the package.
$ db2 "SELECT * from SYSIBM.SYSPACKAGE where name like 'SQLC2E06%'"
SQL0204N "SYSIBM.SYSPACKAGE" is an undefined name. SQLSTATE=42704
How can I do the bind ? Please advise.
Thanks.
-- pk.
On Mon, November 19, 2007 7:33 pm, Stevens Wayne wrote:
> Is this to a connection to MVS?
> It sounds like the package has not been bound. You can verify by
doing
> a SELECT * from SYSIBM.SYSPACKAGE where name like 'SQLC2E06%'; If you
don't
> see that package then you need to do the bind as stated in the quick
> beginnings. If the package is there, then you need to look at the
> contoken. I suspect the package is not there.
>
> Wayne Stevens
> Wayne.[Email address protected]
>
>
>
> -----Original Message-----
> From: pavan
> [mailto:db2udbdba-ezmlmshield-x57388689.[Email address protected]
> Sent: Monday, November 19, 2007 1:23 PM
> To: LazyDBA Discussion
> Subject: SQL0805N Package "NULLID.SQLC2E06 0X4141414141634555" was not
> found
>
> Gurus,
> Just now, I set up a DB2 ODBC connection for a developer. He has
> sufficient access to connect to database and do a select on few
tables. He
> is getting the following error: db2 => select count from xyz.pqr
>
> SQL0805N Package "NULLID.SQLC2E06 0X4141414141634555" was not found.
>
>
> SQLSTATE=51002
>
>
> Tried looking for some help online but in vain. Can you pl help !!
>
>
> P.S: I cataloged the node and database.
>
>
> Thanks,
> pk.
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page