July 20 2010

How to check content of Informix TEMPSPACE when getting fill up?

Tagged Under : , , ,

Scenario:
TEMPSPACE “npts_tmpdbs3” is getting fill up.
We would like to check what is kept in this TEMPSPACE.
$ onstat -d | grep tmpdbs
8426c198 4        2001     4        1        N T      informix npts_tmpdbs1
8426c258 5        2001     5        1        N T      informix npts_tmpdbs2
8426c318 6 2001     6        1        N T      informix npts_tmpdbs3
8426c3d8 7        2001     7        1        N T      informix npts_tmpdbs4
83764f30 4   4   0        512000   509333            PO-   /dev/infdev/npts_tmpdbs1.1
83765038 5   5   0        512000   312458            PO-   /dev/infdev/npts_tmpdbs2.1
83765140 6   6   0        512000   9675              PO-   /dev/infdev/npts_tmpdbs3.1
83765248 7   7   0        512000   509421            PO-   /dev/infdev/npts_tmpdbs4.1

Steps:

(1) Get TBLspace partnum using DBspace number.

Posted by helloworld in Database General, Informix Database
No Comments Read more

June 23 2010

How to change SYSMAN password in Oracle 10g

Tagged Under : , , , , , , ,

I would like to share how to change SYSMAN password in Oracle 10g (10.1 & 10.2) and 11gR1.

Applies to:
Oracle RDBMS 10.1, 10.2 & 11.1

Solution:

Posted by helloworld in Database General, Oracle Database
(1) Comment Read more

June 19 2010

Find top Informix SQL session by using UNIX pid

Tagged Under : , , , ,

Do you have difficulty on finding top informix session by UNIX pid (process id)?

Background:

It is common DBA always been asked “Why informix oninit processes always in UNIX top list? What are they doing?”

In general and with common sense, if an UNIX/Linux box is hosting a (or multiple) Informix database instance(s).   Normally, most of the machine resource (CPU, memory, Disk I/O) will be consumed by Informix instance(s). Oninit processes are the daemons that serve application requests (SQL request) and interact between application and making OS system calls.

Logically, oninit processes can relate to Informix session id.  I have following steps to show how it can be done.

Note:  This may not 100% correct, as user threads are switching between CPU VPs from time to time. You may take as reference to capture repeated patterns.

Posted by helloworld in Database General, Informix Database
No Comments Read more
« Older Entries
Newer Entries »