Register | Login

Published Articles

Modifying Existing Buffer pools

Posted by jyothsnav 2287 days ago (Editorial)

Earlier we have seen how to create the Bufferpool in DB2, this article explains you to modify the sizes of existing buffer pools. Because of data constantly changes, it is easy to see how it may be necessary to modify the sizes of existing buffer pools many times in order to maintain optimal performance.This can be done by using the ALTER BUFFERPOOL command.


Syntax:

DB2 CREATE DB in Restrictive Mode

Posted by jyothsnav 2366 days ago (Editorial)
DB2 CREATE DB SAMPLE RESTRICTIVE

RESTRICTIVE

If the RESTRICTIVE option is present it causes the restrict_access database configuration parameter to be set to YES and no privileges or authorities are automatically granted to PUBLIC.

If the RESTRICTIVE option is not present then the restrict_access database configuration parameter is set to NO and all of the following privileges are auto
Audit facility performance and administration have been enhanced

The audit utility generates a trail of audit records for a series of predefined and monitored database events. Version 9.5 offers major enhancements to the audit facility.

The enhancements to the DB2 audit facility for Version 9.5 include fine grained configuration, new audit categories, separate instance and database logs, an

ADMIN_CMD ROUTINE in DB2

Posted by jyothsnav 2366 days ago (Editorial)
The ADMIN_CMD procedure is used by applications to run administrative commands using the SQL CALL statement. The procedure supports many DB2 command line processor commands like EXPORT, IMPORT, LOAD, RUNSTATS, REORG INDEXES/TABLE, BACKUP, UPDATE / RESET DB/DBM PARAMETERS, FORCE APPLICATIONS etc.,

Usage notes on few administrative commands:

EXPORT/IMPORT/LOAD

The following example shows

DB2CKBKP(Check Backup) Utility to identify logs

Posted by jyothsnav 2368 days ago (Editorial)
This utility can be used to test the integrity of a backup image and to determine whether or not the image can be restored. It can also be used to display the metadata stored in the backup header.
Its even used to identify the required logs to rollforward the database from the backup image

To get the log detail from backup image without restoring the database, using db2ckbkp command we can r

After restoring the production data to a test enviorment database and while doing rollforward, we might experience an issue that the temporary tablespace could not be rollforwarded due to more redo.


This error is not an issue, db2 itself will continue to rollforward the database. After connecting to the database, it will mention that particular tablespace is in rollforward pending stat

Disk full error while doing rollforward

Posted by jyothsnav 2201 days ago (Editorial)

While doing rollforward, we might experience a state where in the disk will be full. During that scenarios, try to find out the file system which is full and do the cleanup; reissue the command again after checking the query status


For ex:


newlogpath parameter i.e. /db2/data/ is full while doing rollforward


disk full error shown in db2diag.log


change the newlogp

SQL1035N The database is currently in use

Posted by jyothsnav 2201 days ago (Editorial)

While doing backup or rollforward database, when the user try to connect to the database the following error will be displayed i.e.


SQL1035N The database is currently in use


Example:


db2 backup db sample compress (or)


db2 rollforward db sample to <timestamp> stop overflow log path ('file path')


(status could be seen using db2 list utilities show de

ERWIN - Reverse Engineer

Posted by jyothsnav 2203 days ago (Editorial)

To generate an Entity Relationship diagram for any existing database structure, please follow the below steps
Tools-Reverse Engineer
Reverse Engineer-Select Template will be opened with the following options
New Model type Physical  Logical/Physical
Target Database
Database DB2/UDB Version: 8.x/9/x (Next/Cancel)
Reverse Engineer-Set Options
Reverse Engin


Before DB2 clients (applications) connect to a database, you must ensure that the server side communications are setup properly to accept the connection requests.To prepare a server for TCP/IP connections, please set up the listener as follows :


1. Set the DB2 profile registry, DB2COMM, to enable the instance to listen for connections from TCP/IP ie.


db2set DB2COMM=TCP/IP



WebServer Apache Benchmarking

Posted by raje2009 (#60) 2336 days ago (Editorial)

Apache Benchmarking


Apache Benchmarking is to find the number of request per second and to count the number of requests can be handled by a webserver instance for a website.


ab (apache benchmarking) is a tool which helps to shows how many requests per second can apache instance is capable of serving.


localhost@userid# ./ab.e

Sort News
Username:

Password:

Remember:
YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.