Instance or Database Manager
DB2 Instance or Database Manager
- An Instance is also called as database Manager as it manages all the database within it.
- It has it own
- processes
- configuration file
- diagnostic log files.
- A log file "db2diag.log" per instance is generated. It location is specified by the dbm cfg file parameter "Diagnostic data directory path (DIAGPATH)"
- Depth of logging Level in "db2diag.log" is specified by the dbm cfg file parameter "Diagnostic error capture level (DIAGLEVEL) ", by default its level is set to 3.
- Following are the five levels of diagnostic log: -
- No diagnostic messages captured (not recommended)
- Severe errors only
- All errors
- All errors and warnings (default)
- All errors and warnings and informational messages
- Following are the List of commands for Creating, Managing and Dropping Instance.(Note:- All commands are executed at windows level command prompt)
- db2icrt
- Create a DB2® instance, including a DB2 pureScale® instance.
- db2idrop
- Removes a DB2® instance that was created by db2icrt.
- db2ilist
- Lists all the instances that are created using the db2icrt command
- db2imigr(db2iupgrade in 10.1 version)
- The db2iupgrade command upgrades an instance from a DB2 copy of a previous release to a DB2 copy of the current release.
- db2iupdt
- The db2iupdt command can be used to update an instance to a higher level within a release
- db2start
- To start an instance
- db2stop
- To stop an instance
- db2iauto
- Enables or disables the autostart of an instance after each system restart. This command is available on Linux and UNIX operating systems only
- db2instance
- The db2instance command is used to query the state of a DB2® instance
- db2iprune
- The db2iprune command can reduce the size of your DB2® product installation image before installation.
- db2isetup
- Starts the DB2 Instance Setup wizard, which is a graphical user interface (GUI) tool for creating, configuring, and extending instances.
No comments:
Post a Comment