Register | Login

Published Articles » Database

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 2386 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 2386 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 2388 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



Buffer pools

Posted by jyothsnav 2523 days ago (Editorial)

The database buffer pool area is a piece of memory used to cache a table's index and data pages as they are being read from disk to be scanned or modified. The buffer pool area helps to improve db system performance by allowing data to be accessed from memory instead of from disk. Because memory access is much faster than disk access, the less often that DB2 needs to read from or write to a di


Listing, migrating, and updating a DB2 instance

Posted by jyothsnav 2523 days ago (Editorial)

1. To list the instances that exist on a server, use the command


db2ilist


2. Instance migration is required if you decide to move up to a newer version of the DB2 software than is installed on your server, or if an instance is to be migrated from a 32-bit to a 64-bit instance.


On Windows, instance migration is done implicitly during the necessary migrat

SMS and DMS table spaces

Posted by jyothsnav 2525 days ago (Editorial)

Table spaces are used to control where data is physically stored and to provide a layer of indication between db objects and one or more containers in the which the objects actual data resides. A single table space can spam many containers but each container can belong to only one tablespace. 


Two types of table spaces can exist: System managed space (SMS) table spaces and Databas

Creating a DB2 V9 Database

Posted by jyothsnav 2525 days ago (Editorial)

There are two ways to create a database i.e. by using create database wizard or CREATE DATABASE command. We will look the command method in this article:


Syntax:


CREATE [DATABASE | DB ] [DatabaseName]


where:


DatabaseName - Identifies a unique name that is to be assigned to the database once it is created


The only value you must provide when executing thi

What happens when DB2 V9 database is created

Posted by jyothsnav 2525 days ago (Editorial)

Whenever a new DB2 database is created, the following tasks are performed:


1. All directories and subdirectories needed are created in the appropriate location i.e. if no location is information is provided with the create database command, this directory tree is created in the dftdbpath DB2 database Manager configuration parameter. The root directory

ORACLE RMAN CLONE WITH AUXILIARY

Posted by venky (#110) 2550 days ago (Editorial)
1) CREATE PFILE WITH DB_FILE_NAME_CONVERT=(OLD PATH,NEW PATH)
2) CREATE DIRECTORY STRUCTURES AS PER PFILE.
3) RMAN TARGET SYS/PASSWORD@TNSNAMES AUXILIARY /
RUN
{
ALLOCATE CHANNEL D1 DEVICE TYPE DISK FORMAT 'BACKUP LOCATION';
DUPLICATE TARGET DATABASE TO NEW DB NAME;
}


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.