Hi,

I had a problem on some command in this DB2 v8.1.11.973. There are more eg: call get_dbsize_info(?,?,?,0) was not recognize also. Is that so incompatible? I had no problem in DB2 v9.7..

db2=> GET DATABASE CONFIGURATION
SQL1651N The request cannot be executed because the DB2 server version does not support this functionality.

db2 => list tablespaces
SQL1651N The request cannot be executed because the DB2 server version does
not support this functionality.

Probably your client version does not match that of the server.

Try Data Studio: Download : IBM Data Studio V3.1

Thanks. The command error was from DB2 Command Line Processor (CLP).

are you logon local to the server..
is it I/series ?
please specify some details about server - client.. operation - errors ??

DB2(v8) was install on top of AS400(v5) platform server,

I use Windows Client DB2 Command Line Processor (CLP). to connect to server and run the below command.

db2=> GET DATABASE CONFIGURATION
SQL1651N The request cannot be executed because the DB2 server version does not support this functionality.

db2 => list tablespaces
SQL1651N The request cannot be executed because the DB2 server version does
not support this functionality.

not all command are the same for all db2 editions
try a simple select..
it is possible that i/series does not have the command get db cfg ...
check the doc of db2/400 with supported commands
tablespaces is also something specific and does not exist on some platforms (as I/series ??)
http://publib.boulder.ibm.com/infoce...v5r3/index.jsp

Thank you very much.. It's really help me a lot..