Register | Login

Published Articles

SMS and DMS table spaces

Posted by jyothsnav 2400 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 2400 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 2400 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

redirect top output to the file

Posted by raje2009 (#67) 2416 days ago (Editorial)

Command to redirect the top output to a file.


top -b  -p 12345  -d 10 >> /tmp/stg01_top


We can also redirect multiple pid output to a file in a single line command as below


top -b  -p 12345,6789,9012  -d 10 >> /tmp/stg02_top


-b : Batch mode operation
            Starts to

top command in Linux

Posted by raje2009 (#67) 2416 days ago (Editorial)

 top - display Linux tasks/process, cpu utilization, load average and memory utilization.


 


To check the swap memory occupied by a process or PID through top command.


Enter the top command and enter ShiftO (O is alphabet)  to choose the various field available among the top command


 


Type p to select the SWAP

ORACLE RMAN CLONE WITH AUXILIARY

Posted by venky (#81) 2426 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;
}


If the user is having system administrator(SYSADMN) or System control (SYSCTRL) or SYSMAINT or SYSMON authority for a DB2 database server, you can find out who is using an instance or a database on that server by executing the LIST APPLICATIONS command.


 


Syntax:


LIST APPLICATIONS


where DATABASEALIAS - is the alias assigned to the database during the databa

Pligg CMS Wrong Referrer http error

Posted by maspire 2425 days ago (Editorial)
Some times when we access the admin screen we might face the error
Wrong Referrer 'http://localhost/Pligg%201.0.0%20RC4/admin/admin_config.php'.


This means the my_base_url value in the settings.php file is incorrect.

Follow the below steps

Creating a DB2 instance using db2icrt

Posted by jyothsnav 2423 days ago (Editorial)
An instance is a logical database manager environment where you catalog databases and set configuration parameters

Lets see how to create an instance using db2icrt

Prerequisites
- On Linux or UNIX, you must have root user authority.
- On Windows, you must be logged on as a Local Administrator.
- And create the user/set the password/update expire date i.e. instance we are going to creat

AIX CRONTAB

Posted by venky (#81) 2426 days ago (Editorial)
00 19 * * *
#15 10 27 7
add the values to crontab
edit to cron =crontab -e and list crontab -l

00 19 * * * /script location dbname 2>&1


* * * * * command to be executed
- - - - -
| | | | |
| | | | +----- day of week (0 - 6) (Sunday=0)
| | | +------- month (1 - 12)
| | +--------- day of month (1
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.