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


DB2 & UDB email list listserv db2-l LazyDBA home page