Question Re: Error when executing "db2 get db cfg" command in Technology Q&A

Error when executing "db2 get db cfg" command

Former Member — Sun, 11 Jan 2009 13:15:54 GMT

Hi,

I am working on db2 for the first time. I have installed SAP ERP 6.0 on Windows 2003 server with db2 v9.1 FP 5.

I am trying to check the db parameter using the tool installed in windows automatically while installing sap.

start -- all programs -- IBM DB2 -- SAPDB2IDS - Command line tool -- command window.

I have logged into server as <sid>adm.

I am executing the command from the path E:\db2\db2ids\db2_software\BIN>.

I am getting output for

#db2 get dbm cfg.

But when i execute command,

#db2 get db cfg, I am getting below error,

SQL1024N A database connection does not exist. SQLSTATE=08003

Please let me know what setting I have to do before using this tool.

Regards,

Nallasivam.D

Former Member — Sun, 11 Jan 2009 14:06:38 GMT

Hi,

It started to working after a db restart.

Regards,

Nallasivam.D

Former Member — Thu, 12 Feb 2009 12:54:03 GMT

Hi,

No db restart required actually.

Simply login into the Windows Server 2003 with db2sid user

Go to command prompt

execute db2cmd

then execute

db2 connect to SID

It will show you the default database schema connection

After that,execute db2 ger db cfg for SID

It will show you the DB2 parameter values for your schema

There`s a concept of DBM or database manager, the configuration of which you can check with:

db2 get dbm cfg

DBM is the super-set and DB Schema is the subset

Hope the confusion gets clear.

Regards,

Rahul.