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

IP Delivery Concept

By
It is the practice of using the IP, the network address of the connecting computer, whether robot or human, and sending different content based on that. The database used to assist with the process. In the case of geo-targeting: Databases stores various ranges of IP addresses, and indicates where this ranges of IPs are in the world. A geo-targeting script scans the list to see in which country the current IP is located. Programmer can use this value to effect changes in presentation or logic. In the case of cloaking : Databases stores the IP addresses of the various spiders that may hit your site. The cloaking script scans the list to see if the current IP is a spider. The programmer can use this information to effect changes in presentation or logic. Implementations of IP-delivery-based cloaking also look at the User-Agent header of the request. The user agent header is a header sent by both browsers and spiders. But it is not regarded authoritative, bec
1 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