2011-02-02-09.41.40.900206+180 E2941047E946        LEVEL: Warning
PID     : 14018                TID  : 47939061803328PROC : db2sysc
INSTANCE: db2inst              NODE : 000          DB   : STRAH
APPHDL  : 0-107                APPID: *LOCAL.db2inst.110202064140
AUTHID  : DB2INST 
EDUID   : 111                  EDUNAME: db2agent (STRAH)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
9825222656

2011-05-30-18.45.13.050690+240 I159097054E1030     LEVEL: Error
PID     : 5507                 TID  : 1118218560   PROC : db2acd
INSTANCE: db2inst              NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, DasCommFactory::isLocalHost, probe:20
DATA #1 : signed integer, 4 bytes
-2146500356
CALLSTCK: 
  [0] 0x00002B9B1318D254 pdOSSeLoggingCallback + 0x100
  [1] 0x00002B9B149EEFF4 /home/db2inst/sqllib/lib64/libdb2osse.so.1 + 0x1C0FF4
  [2] 0x00002B9B149F0810 ossLog + 0xA6
  [3] 0x00002B9B1AAB9824 _ZN14DasCommFactory11isLocalHostEPcPa + 0x280
  [4] 0x00002B9B1AAB78BE _ZN14DasCommFactory16getCommInterfaceEP7dasInfoiPP16DasCommInterfaceP5sqlca + 0x116
  [5] 0x00002B9B1AAAA0BF _ZN14DasCommAdapter10dasRequestEP15dasRequestInputP13requestOutput + 0xF7
  [6] 0x00002B9B1AAB23F2 _ZN6DasAPI3runEv + 0x1B6
  [7] 0x00002B9B18E32456 _ZN13hiAlertCfgMgr21buildNotificationListEv + 0xFEC
  [8] 0x00002B9B18E31289 _ZN13hiAlertCfgMgr7refreshEb + 0x3C5
  [9] 0x00002B9B18E1FE21 _ZN15hiDataCollector17updateRefreshSetsEv + 0x14D

2011-05-30-18.45.13.050690+240 I159097054E1030     LEVEL: Error
PID     : 5507                 TID  : 1118218560   PROC : db2acd
INSTANCE: db2inst              NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, DasCommFactory::isLocalHost, probe:20
DATA #1 : signed integer, 4 bytes
-2146500356
CALLSTCK: 
  [0] 0x00002B9B1318D254 pdOSSeLoggingCallback + 0x100
  [1] 0x00002B9B149EEFF4 /home/db2inst/sqllib/lib64/libdb2osse.so.1 + 0x1C0FF4
  [2] 0x00002B9B149F0810 ossLog + 0xA6
  [3] 0x00002B9B1AAB9824 _ZN14DasCommFactory11isLocalHostEPcPa + 0x280
  [4] 0x00002B9B1AAB78BE _ZN14DasCommFactory16getCommInterfaceEP7dasInfoiPP16DasCommInterfaceP5sqlca + 0x116
  [5] 0x00002B9B1AAAA0BF _ZN14DasCommAdapter10dasRequestEP15dasRequestInputP13requestOutput + 0xF7
  [6] 0x00002B9B1AAB23F2 _ZN6DasAPI3runEv + 0x1B6
  [7] 0x00002B9B18E32456 _ZN13hiAlertCfgMgr21buildNotificationListEv + 0xFEC
  [8] 0x00002B9B18E31289 _ZN13hiAlertCfgMgr7refreshEb + 0x3C5
  [9] 0x00002B9B18E1FE21 _ZN15hiDataCollector17updateRefreshSetsEv + 0x14D

create audit policy objmaint categories objmaint status both error type normal audit database using policy objmaint;
alter audit policy objmaint categories context status none error type normal;
-- архивируем файл и запоминаем его имя
SELECT file FROM TABLE(SYSPROC.AUDIT_ARCHIVE('/some_directory', - 2 )) AS T1
-- извлекаем информацию из этого файла
CALL SYSPROC.AUDIT_DELIM_EXTRACT(NULL, '/some_directory', '/some_directory', 'file_name_from_previous_call',  'OBJMAINT');

Operating System Information:

OSName:   Linux      
NodeName: sl00700030002 
Version:  2                    
Release:  6          
Machine:  x86_64     

CPU Information:
TotalCPU    OnlineCPU   ConfigCPU   Speed(MHz)  HMTDegree  Cores/Socket
16          16          16          1596        1           8          

Physical Memory and Swap (Megabytes):
TotalMem    FreeMem     AvailMem    TotalSwap   FreeSwap   
16028       7977        n/a         4001        4001        

Virtual Memory (Megabytes):
Total       Reserved    Available   Free       
20029       n/a         n/a         11978       

Message Queue Information:
MsgSeg      MsgMax      MsgMap      MsgMni      MsgTql      MsgMnb      MsgSsz               
n/a         65535       65536       1024        65536       65536       16          

Shared Memory Information:
ShmMax               ShmMin               ShmIds      ShmSeg      
1073741824           1                    4096        4096        

Semaphore Information:
SemMap      SemMni      SemMns      SemMnu      SemMsl      SemOpm      SemUme      SemUsz      SemVmx      SemAem      
256000      1024        256000      256000      250         32          n/a         20          32767       32767       

CPU Load Information:
Short     Medium    Long      
0.090000  0.050000  0.010000  

CPU Usage Information (percent):
Total     Usr       Sys       Wait      Idle      
0.562500  n/a        n/a        n/a        99.437500 

Database Partition 0 -- Active -- Up 0 days 20:05:58

Database Partition Memory Controller Statistics

Controller Automatic: N
Memory Limit:         15728640 KB
Current usage:        8514240 KB
HWM usage:            9840960 KB
Cached memory:        396544 KB

Individual Memory Consumers:

Name             Mem Used (KB) HWM Used (KB) Cached (KB)
========================================================
APPL-STRAH               15552        160000        8192
DBMS-db2inst             48384         48384        6720
FMP_RESOURCES            22528         22528           0
PRIVATE                  34176        341440        7360
DB-STRAH               8393600       8393600      374272

db2 get dbm cfg | grep INSTANCE
db2 get db cfg | grep -E "DATABASE_MEMORY|SELF"

(INSTANCE_MEMORY) = 3932160

AUTOMATIC (3519488)

(SELF_TUNING_MEM) = OFF
(DATABASE_MEMORY)= AUTOMATIC(2398160)

2011-06-01-22.01.07.654241+240 E161734712E946      LEVEL: Warning
PID     : 24772                TID  : 47652158826816PROC : db2sysc
INSTANCE: db2inst              NODE : 000          DB   : STRAH
APPHDL  : 0-159                APPID: *LOCAL.db2inst.110601180107
AUTHID  : DB2INST 
EDUID   : 142                  EDUNAME: db2agent (STRAH)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
9822863360

2011-06-02-10.24.58.177974+240 I162284745E1004     LEVEL: Error
PID     : 24787                TID  : 1097267520   PROC : db2acd
INSTANCE: db2inst              NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, DasCommTcpIpAdapter::connect, probe:50
CALLSTCK: 
  [0] 0x00002B8CF97AD254 pdOSSeLoggingCallback + 0x100
  [1] 0x00002B8CFB00EFF4 /home/db2inst/sqllib/lib64/libdb2osse.so.1 + 0x1C0FF4
  [2] 0x00002B8CFB01083E ossLog + 0xD4
  [3] 0x00002B8D010D5745 _ZN19DasCommTcpIpAdapter7connectEiP5sqlca + 0xE3
  [4] 0x00002B8D010CA45F _ZN20DasClientCommManager10dasRequestEP16DasCommInterfaceP15dasRequestInputP13requestOutput + 0x9D
  [5] 0x00002B8D010CA0E3 _ZN14DasCommAdapter10dasRequestEP15dasRequestInputP13requestOutput + 0x11B
  [6] 0x00002B8D010D23F2 _ZN6DasAPI3runEv + 0x1B6
  [7] 0x00002B8CFF452456 _ZN13hiAlertCfgMgr21buildNotificationListEv + 0xFEC
  [8] 0x00002B8CFF451289 _ZN13hiAlertCfgMgr7refreshEb + 0x3C5
  [9] 0x00002B8CFF43FE21 _ZN15hiDataCollector17updateRefreshSetsEv + 0x14D

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
kernel.sem=250 256000 32 1024
kernel.msgmax=65535
kernel.msgmnb=65535
kernel.shmall=3487493
kernel.shmmax=1073741824

# Added 25.02.2010
net.ipv4.conf.all.arp_announce=1
net.ipv4.conf.all.arp_ignore=2

rebind()
{
db2 CONNECT TO STRAH
db2 UPDATE DB CFG FOR STRAH USING DFT_QUERYOPT  9 
db2 CONNECT RESET
db2 FORCE APPLICATION ALL
db2stop
db2start
cd /builds/installer/database && ./run.sh drop-logic
cd /builds/installer/database && ./run.sh create-logic
db2 CONNECT TO STRAH
db2 UPDATE DB CFG FOR STRAH USING DFT_QUERYOPT  5 
db2 CONNECT RESET
}