Tuesday, December 1, 2009

How To Setup IBM DB2 Database Configuration


01. Click Start on the Windows Toolbar

02. Click Run.

03. Type db2cw on the Open combo box and click OK button

=== please wait until DOS Prompt appears

04. On the DB2 Command Window, type the following commands and press Enter key for each line of command:

db2

=== please wait until DB2 Prompt appears

connect to (database name) user (usename) using (password)

UPDATE DATABASE CONFIGURATION USING AUTO_MAINT On DEFERRED

UPDATE DATABASE CONFIGURATION USING AUTO_DB_BACKUP On IMMEDIATE

UPDATE DATABASE CONFIGURATION USING AUTO_TBL_MAINT On DEFERRED

UPDATE DATABASE CONFIGURATION USING AUTO_RUNSTATS On DEFERRED

UPDATE DATABASE CONFIGURATION USING AUTO_REORG On DEFERRED

UPDATE DATABASE CONFIGURATION USING DBHEAP 600 IMMEDIATE

UPDATE DATABASE CONFIGURATION USING APP_CTL_HEAP_SZ 128 DEFERRED

UPDATE DATABASE CONFIGURATION USING LOCKLIST 50 IMMEDIATE

UPDATE DATABASE CONFIGURATION USING APPGROUP_MEM_SZ 30000 DEFERRED

UPDATE DATABASE CONFIGURATION USING DATABASE_MEMORY 9456 IMMEDIATE

connect reset

QUIT

EXIT

Add To Google BookmarksStumble ThisFav This With TechnoratiAdd To Del.icio.usDigg ThisAdd To RedditTwit ThisAdd To FacebookAdd To Yahoo

0 comments:

Post a Comment

Related Posts with Thumbnails
 

Privacy Policy for coderschoice.blogspot.com

If you require any more information or have any questions about our privacy policy, please feel free to contact us by email at fbascara@yahoo.com.

At coderschoice.blogspot.com, the privacy of our visitors is of extreme importance to us. This privacy policy document outlines the types of personal information is received and collected by coderschoice.blogspot.com and how it is used.

Log Files Like many other Web sites, coderschoice.blogspot.com makes use of log files. The information inside the log files includes internet protocol ( IP ) addresses, type of browser, Internet Service Provider ( ISP ), date/time stamp, referring/exit pages, and number of clicks to analyze trends, administer the site, track user’s movement around the site, and gather demographic information. IP addresses, and other such information are not linked to any information that is personally identifiable.

Cookies and Web Beacons coderschoice.blogspot.com does not use cookies.

DoubleClick DART Cookie

.:: Google, as a third party vendor, uses cookies to serve ads on coderschoice.blogspot.com. .:: Google's use of the DART cookie enables it to serve ads to your users based on their visit to coderschoice.blogspot.com and other sites on the Internet. .:: Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy at the following URL - http://www.google.com/privacy_ads.html

Some of our advertising partners may use cookies and web beacons on our site. Our advertising partners include ....... Google Adsense

These third-party ad servers or ad networks use technology to the advertisements and links that appear on coderschoice.blogspot.com send directly to your browsers. They automatically receive your IP address when this occurs. Other technologies ( such as cookies, JavaScript, or Web Beacons ) may also be used by the third-party ad networks to measure the effectiveness of their advertisements and / or to personalize the advertising content that you see.

coderschoice.blogspot.com has no access to or control over these cookies that are used by third-party advertisers.

You should consult the respective privacy policies of these third-party ad servers for more detailed information on their practices as well as for instructions about how to opt-out of certain practices. coderschoice.blogspot.com's privacy policy does not apply to, and we cannot control the activities of, such other advertisers or web sites.

If you wish to disable cookies, you may do so through your individual browser options. More detailed information about cookie management with specific web browsers can be found at the browsers' respective websites.