Skip to main content

DB2 Instance

By
It is defined as a logical data server environment. All databases are created within instances on data servers. When multiple instances are created  on same server it provides a unique database server environment using which you can differentiate your tasks going on, such as maintain a testing environment and a production environment on same machine.

You may have different administrative groups working with different instances. Information related to instances are stored in instance directory. Location of instance directory cant be changed once created. It contains information like:

· Database manager configuration file
· System database directory
· Node directory
· Node configuration files
· Other files containing debugging information

DB2 Storage Model


To create an instance in windows you have to write following command:
            db2icrt

To start an instance:
            DB2START
            NET START (for windows)

To stop an instance:
            DB2STOP
            NET STOP (for windows)

To restart an instance:
            DB2STOP & DB2START

To obtain name of currently active instance:
            GET INSTANCE

Labels:

Comments

Post a Comment

Popular posts from this blog

Quiz 1 : Mobile Application Development - Android

By
Download PDF Version From Here   MCQ 1. Select a component which is NOT part of Android architecture. a. Android framework   b. Libraries          c. Linux kernel   d. Android document 2. What is AAPT? a. Android Asset Processing Tool.             b. Android Asset Providing Tool.   c. Android Asset Packaging Tool.             d. Android Asset Packaging Technique 3. Required folder when Android project is created. a. build                 b. build/               c. bin     d. bin/ 4. Adb stands for   A. Android Drive Bridge.                              B. Android Debug Bridge.            C. Android Destroy Bridge.                          D. Android Delete Bridge. 5. Is list data type supported by AIDL? a. Yes    b. No 6. Component which is NOT under the Android application. a. Content providers      b. Resource externalization         c. Applications d. Notifications 7. Language which is supported by Android for application dev
Post a Comment
Read more

Never try to go back and repair the past which is impossible. But be prepared to construct the future which is possible.

By
Never try to go back and repair the past which is impossible. But be prepared to construct the future which is possible.
Post a Comment
Read more

Computer problems : Some Information and Knowledge Base

By
Computer problems are not new to a person with a regular PC at home or at work. Problems can range from simple problems such as frozen screens and the dungeons of the main issues to work as falling food and hard disk crash. A long list of computer problems are bound to occur, some of which can be easily eliminated by turning off the computer and clicking Restart. However, there are other serious issues that can not be solved without the help of an experienced or a professional. If you find a problem like this, you can always consider calling the IT professional to get their problem solved, but just before placing callers you would do well to analyze all common computer problems and see if they can solve the problem itself. In situations that require professional intervention, such as a virus attack, it would be prudent to take a back seat of your system and to appeal to professionals. Contrary to the thinking of many people where computers are considered magical machinery, computer
Post a Comment
Read more