Register | Login

Published Articles » Database

Conceptual, logical and physical schemas

Posted by jyothsnav 2471 days ago (Editorial)

A data model instance may be one of 3 kinds:


Conceptual Schema: describes the semantics of a domain, being the scope of the model. For example, it may be a model of the interest area of an organization or industry. This consists of entity classes, representing kinds of things of significance in the domain, and relationships assertions about associations between pai

DB2 Load Utility

Posted by jyothsnav 2460 days ago (Editorial)

Like the Import utility, the LAOD utility is designed to read data directly from an external file and store it in a specific table. However, unlike when the import utility is used, when the Load utility is used the table to which data is to be copied must already exist in the database before the load operation is initiated.


Syntax:


LOAD FROM [filename] OF [DEL|ASC|IXF]



DB2MOVE utility

Posted by jyothsnav 2460 days ago (Editorial)

Its easy to see how the export utility can be used together with the import utility or load utility to copy a table from one database to another, but what if we want to copy several tables or an entire database?


In this case, data can be copied table by table using export/import/load but a more efficient way to copy an entire DB2 database is by using the DB2MOVE utility.


DB2MOV

DB2 Import Utility

Posted by jyothsnav 2461 days ago (Editorial)

One way to copy data from an external file to a database is by using DB2's import utility; the import utility is desgined to read data directly from an external file (provided the file is written in a format that is supported by DB2) and insert it in a specific table or updatable view.


Syntax:


IMPORT FROM [filename] OF [DEL|ASC|IXF|WSF]


COMMITCOUNT [commitcount] | COMMI

DB2 Export Utility

Posted by jyothsnav 2461 days ago (Editorial)

The export utility is designated to extract data from a DB2 database table or view and externalize into a file using the file formats like DEL (Delimited ASCII), WSF (worksheet format), IXF (PC Information Exchange Format). Such files can then be used to provide data values to other databases and software applications such as spreadsheets and word processors.


Syntax:


EXPORT TO

SQL0911N and SQL0913N Error Code

Posted by jyothsnav 2471 days ago (Editorial)

 


SQL0911N - The current transaction has been rolled back because of a deadlock or timeout. Reason code (reason-code)


SQL0913N - Unsuccessful execution caused by deadlock or timeout. Reason code (reason-code)


The current unit of work was involved in an unre

Modifying Existing Buffer pools

Posted by jyothsnav 2471 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 2550 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 2550 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 2552 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
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.