Register | Login

Published Articles

top command in Linux

Posted by raje2009 (#93) 2540 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 (#109) 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;
}


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 2549 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 2547 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 (#109) 2550 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

ORACLE DATAGUARD FAILOVER

Posted by venky (#109) 2550 days ago (Editorial)

6.2 Failover from the Primary to the Standby Database (Disaster Recovery)
Perform following tasks to do failover:

1. Identify and resolve any archivelog gaps. On the standby database server, execute the following statement:
SQL> select * from v$archive_gap;
no rows selected
If this query returns any rows, copy the archivelogs file to the primary site and check whether is is applied
Error:
SQL0965C The transaction log for the database is full

Remedy:

1. Increase primary and secondary logs i.e.
In V9 - logprimary + logsecond=256
In V8 - logprimary + logsecond=250

db2 update db cfg for sample using logprimary X
db2 update db cfg for sample using logsecond X

2. Look for the query that is running, try modifying it by using where condition
3. Issue frequent c

SQL Best Practices for Query Performance

Posted by jyothsnav 2550 days ago (Editorial)
Query performance is not a one-time consideration. You should consider it throughout the design, development, and production phases of the application development life cycle.

Query Coding General Guidelines:

Example:
LINE1: SELECT ISPFOLIO.ISACCOUNTNO, ISPFOLIO.FUNDCODE, FUND.NAME, ISCUST.ISACCOUNTNAME
LINE2: FROM ISPFOLIO, ISCUST, FUND
LINE3: WHERE ----
LINE4: AND BRANCHCODE = ‘020’
db2ckbkp - Check backup command

DB2 UDB provides an utility to test the integrity of backup image and to determine whether or not the image can be restored. For details about options, run db2ckbkp with no arguments.

db2ckbkp -h

1. Displays media header information including the name and path of the image expected by the restore utility.
2. We could also find out that the backup image i

Listing of OS Processes and threads in DB2

Posted by jyothsnav 2553 days ago (Editorial)

Prior to DB2 9.5, on UNIX and Linux environments with the help of the ps system command or the db2_local_ps command, you were able to list all active DB2 EDUs. However, in DB2 9.5 those commands no longer list any EDU (Engine dispatchable units are responsible for performing various tasks such as processing database application requests) threads within the db2sysc process. Almost all operat


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.