RE: GET_DBSIZE_INFO returns error

RE: GET_DBSIZE_INFO returns error

 

  

Assuming the catalog partition is node 0, that won't help.
Have you set up a tools catalog and corresponding 32k tablespaces?
In any event, this is a symptom of an incomplete DB2 installation and it's
not worth the candle for an outsider to your systems to keep on guessing
where the goof-up is. There are literally dozens of hits for SQL0443N in
LazyDBA and other communities, suggest you research those.
Regards
Alex

> -----Original Message-----
> From: Jagdish Singh Rawat NCS
> [mailto:db2udbdba-ezmlmshield-x18732777.[Email address protected]
> Sent: 22 May 2008 08:53
> To: LazyDBA Discussion
> Subject: RE: GET_DBSIZE_INFO returns error
>
> Try
> db2 call get_dbsize_info(?,?,?,1)
>
> Regards,
>
> Jagdish S. Rawat
> IBM Certified Advance DB2DBA
> NCS Pte. Ltd.
> 5 Ang Mo Kio St 62, NCS Hub
> Singapore - 569141
> Ph.# +65-65565870(Direct) +65-65568000 Ext. # 5870 HP.#
> +65-96425135 Fax# +65-64830495
>
> -----Original Message-----
> From: Raghunandan
> [mailto:db2udbdba-ezmlmshield-x16636547.[Email address protected]
> Sent: Thursday, May 22, 2008 3:04 PM
> To: LazyDBA Discussion
> Subject: RE: GET_DBSIZE_INFO returns error
>
> This is not working.Any other suggestions.
>
> *****************************************************************
>
>
>
> This e-mail and its attachments contain confidential
> information from HUAWEI, which is intended only for the
> person or entity whose address is listed above. Any use of
> the information contained herein in any way (including, but
> not limited to, total or partial disclosure, reproduction, or
> dissemination) by persons other than the intended
> recipient(s) is prohibited. If you receive this e-mail in
> error, please notify the sender by phone or email immediately
> and delete it!
>
>
>
> *****************************************************************
>
> -----Original Message-----
> From: Alex Levy
> [mailto:db2udbdba-ezmlmshield-x69198695.[Email address protected]
> Sent: Wednesday, May 21, 2008 8:32 PM
> To: LazyDBA Discussion
> Subject: RE: GET_DBSIZE_INFO returns error
>
> Try binding the db2schema.bnd file on the database that fails
> (instructions in your fixpack installation readme).
>
> > -----Original Message-----
> > From: Raghunandan
> > [mailto:db2udbdba-ezmlmshield-x12062929.[Email address protected]
> > Sent: 21 May 2008 14:08
> > To: LazyDBA Discussion
> > Subject: GET_DBSIZE_INFO returns error
> >
> > Dear All,
> >
> > I'm getting the following error
> >
> >
> >
> > SQL0443N Routine "SYSPROC.GET_DBSIZE_INFO" (specific name
> > "GET_DBSIZE_INFO")
> >
> > has returned an error SQLSTATE with diagnostic text "SQL0818".
> > SQLSTATE=38553
> >
> >
> >
> > when ever I run the command
> >
> >
> > This problem is happening only on
> >
> >
> >
> > DB21085I Instance "db2inst1" uses "64" bits and DB2 code release
> > "SQL08022"
> >
> > with level identifier "03030106".
> >
> > Informational tokens are "DB2 v8.1.3.88", "s050422", "MI00118", and
> > FixPak "9".
> >
> >
> >
> > But the same command is working correctly on
> >
> >
> >
> > DB21085I Instance "db2inst2" uses "32" bits and DB2 code release
> > "SQL08020"
> >
> > with level identifier "03010106".
> >
> > Informational tokens are "DB2 v8.1.0.64", "s040812", "MI00086", and
> > FixPak "7".
> >
> >
> >
> > Is it to do anything with the 32/64 bit version of db2 or
> am I making
> > any mistake.
> >
> > Please let me know the reason
> >
> >
> >
> > Regards
> >
> > Raghu
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > 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
> >
> >
> >
> >
> >
> >
> > E-mail message checked by Spyware Doctor (5.5.0.212) Database
> > version: 5.09880 http://www.pctools.com/en/spyware-doctor/
>
>
>
>
>
> E-mail message checked by Spyware Doctor (5.5.0.212)
> Database version: 5.09880
> http://www.pctools.com/en/spyware-doctor/
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
>
>
> E-mail message checked by Spyware Doctor (5.5.0.212)
> Database version: 5.09880
> http://www.pctools.com/en/spyware-doctor/





E-mail message checked by Spyware Doctor (5.5.0.212)
Database version: 5.09880
http://www.pctools.com/en/spyware-doctor/

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