v8.1(fp14) GET_DBSIZE_INFO SQL1131N

[Anonymous Sender]

On Win32, db2 v8.1 FP14 , when I call SYSCAT.GET_DBSIZE_INFO(?,?,?,-1) then after some moments I get a SQL1131N.
(A stored procedure terminated abormally).
This is on a newly created database, automatic storage.

Any suggestions?

[Serge Rielau]

Anonymous Sender wrote:

On Win32, db2 v8.1 FP14 , when I call SYSCAT.GET_DBSIZE_INFO(?,?,?,-1) then after some moments I get a SQL1131N.
(A stored procedure terminated abormally).
This is on a newly created database, automatic storage.

Any suggestions?

PMR

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Jan M. Nelken]

Anonymous Sender wrote:

On Win32, db2 v8.1 FP14 , when I call SYSCAT.GET_DBSIZE_INFO(?,?,?,-1) then after some moments I get a SQL1131N.
(A stored procedure terminated abormally).
This is on a newly created database, automatic storage.

Any suggestions?

I believe that schema should be SYSPROC - not SYSCAT. If your
environment is set up correctly, you should be able to issue:

db2 call GET_DBSIZE_INFO(?,?,?,-1)

or

db2 call SYSPROC.GET_DBSIZE_INFO(?,?,?,-1)
Jan M. Nelken