Page History

...

The part marked "Shell>" can be executed at the prompt in the user's account to obtain the result, and the part marked "iSQL>" executes iSQL to access the DB and executes the SQL statement to obtain information.

Monotoring Monitoring item

Method

Analysis result

Existence of Altibase process

Shell> ps -ef | grep "altibase -p boot from" | grep -v grep

1 or more

System free memory

vmstat or command to view memory usage by each OS

Surveillance to maintain 20% margin

Altibase memory usage

SELECT

Code Block

language	sql

SELECT SUM(MAX_TOTAL_SIZE)


FROM

   V$MEMSTAT

Monitors of sudden increase compared to usual usage

Altibase memory DB allocation

SELECT

Code Block

language	sql

SELECT TRUNC((MEM_ALLOC_PAGE_COUNT*32*1024)


       /MEM_MAX_DB_SIZE*100.0, 2)
FROM V$DATABASE
;

FROM

V$DATABASE

;

In the form of monitoring memory DB allocation, the occupancy rate does not exceed 90%

System disk usage

Shell> df –k

Monitors the usage of directories used by Altibase and whether or not it increases sharply compared to the usual usage

Altibase disk DB allocation

SELECT

Code Block

language	sql

SELECT A.NAME,


       A.ALLOCATED_PAGE_COUNT,


       SUM(B.MAXSIZE)


FROM

   V$TABLESPACES A,

V$DATAFILES B

WHERE


       V$DATAFILES B
WHERE  A.ID = B.SPACEID


GROUP

BY

 A.NAME,


          A.ALLOCATED_PAGE_COUNT

Monitors disk DB allocation

Since only the currently allocated space is monitoring relative to the total availability, it is not actual usage. However, it is possible to determine whether to take additional actions when physical data files are insufficient.

Altibase trace log

Check for the existence of error messages beginning with "ERR-"
Shell> tail –f altibase_boot.log | grep "ERR-"

Take an action based on the severity of the ERR error

Monitors whether the following messages are periodically displayed in altibase_sm.log
Remove Online Log File at LFG [0]: File[11252 ~ 11253]

Monitors the normal operation of the checkpoint and whether the log file is deleted normally, and if the number part is continuously displayed as None, it is necessary to check.

Altibase replication status

SELECT

Code Block

language	sql

SELECT REP_NAME,


       REP_GAP


FROM

   V$REPGAP

Monitors whether the REP_GAP item continues to increase

Versions Compared

Old Version 5

New Version Current

Key