MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 60 bytes
Insufficient instance_memory to allocate new memory consumer
DATA #2 : String, 11 bytes
DB-CMD
DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
63997083648
DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes
312410112
DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes
17179869184

FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 8 bytes
CMD
DATA #2 : String, 56 bytes
Insufficient INSTANCE_MEMORY to allocate new memory set.
DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes
976518


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
63997083648


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 28 bytes
Attempt to get memory failed
DATA #2 : unsigned integer, 8 bytes
55997497344
DATA #3 : unsigned integer, 8 bytes
0
DATA #4 : String, 11 bytes
DB-CMD
DATA #5 : unsigned integer, 8 bytes
0
DATA #6 : unsigned integer, 8 bytes
0
DATA #7 : unsigned integer, 8 bytes
312410112
DATA #8 : unsigned integer, 8 bytes
17179869184
DATA #9 : unsigned integer, 8 bytes
208601088


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10
DATA #1 : <preformatted>
Instance Memory Controller statistics.
Instance Memory Automatic: No.
Maximum size = 16777216 KB
Current size = 305088 KB
Usage HWM = 14919104 KB
Cached memory = 203712 KB
Cached DB memory = 0 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11
DATA #1 : <preformatted>
APPL-CMD - Current size : 160000 KB, HWM : 160000 KB, Reserved : 159872 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12
DATA #1 : <preformatted>
DBMS-db2inst2 - Current size : 102784 KB, HWM : 102784 KB, Reserved : 34944 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13
DATA #1 : <preformatted>
FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:14
DATA #1 : <preformatted>
PRIVATE - Current size : 19648 KB, HWM : 47232 KB, Reserved : 8896 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:16
DATA #1 : <preformatted>
DB-CMD - Current size : 0 KB, HWM : 0 KB, Reserved : 0 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:17
DATA #1 : <preformatted>
Aggregated stats for 1 Local Applications Sets
Current size : 128 KB
HWM : 128 KB
Reserved : 0 KB


FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
DIA8300C A memory heap error has occurred.
DATA #1 : String, 60 bytes
Insufficient instance_memory to allocate new memory consumer
DATA #2 : String, 11 bytes
DB-CMD
DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
55997497344
DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes
312410112
DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes
17179869184


FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 8 bytes
CMD
DATA #2 : String, 56 bytes
Insufficient INSTANCE_MEMORY to allocate new memory set.
DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes
854454

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
55997448192


FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:125
DATA #1 : Hexdump, 4 bytes
0x0780000002A858DC : FFFF FBA3 ....


FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: CMD : DEACTIVATED: NO

db2 => RESTORE DATABASE
SQL2539W Warning! Restoring to an existing database that is the same as the
backup image database. The database files will be deleted.
Do you want to continue ? (y/n) y
SQL2563W The restore process has completed successfully, but one or more
table spaces from the backup were not restored.
db2 => connect to DATA
SQL1117N A connection to or activation of database "DATA" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
db2 =>

FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10010
CHANGE : HADR role set to Standard (was Standard)

FUNCTION: DB2 UDB, database utilities, sqludBMResponse, probe:678
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
2563
DATA #2 : Hexdump, 4 bytes
0x07000000436C4868 : 0000 0A03 ....

FUNCTION: DB2 UDB, database utilities, sqludBMResponse, probe:678
MESSAGE : SQL2563W The restore process has completed successfully, but one or
more table spaces from the backup were not restored.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 2563 sqlerrml: 0
sqlerrmc:
sqlerrp : sqludBMR
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:779
MESSAGE : Restore Complete.

DB20000I The RESTORE DATABASE command completed successfully.
db2 => connect to DATA
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019

Operating System Information:

OSName: AIX
NodeName: hostname
Version: 6
Release: 1
Machine:

CPU Information:
TotalCPU OnlineCPU ConfigCPU Speed(MHz) HMTDegree Cores/Socket
32 16 32 3300 2 n/a

Physical Memory and Swap (Megabytes):
TotalMem FreeMem AvailMem TotalSwap FreeSwap
16384 527 n/a 512 459

Virtual Memory (Megabytes):
Total Reserved Available Free
16896 n/a n/a 986

Message Queue Information:
MsgSeg MsgMax MsgMap MsgMni MsgTql MsgMnb MsgSsz
n/a 4194304 n/a n/a n/a 4194304 n/a

Shared Memory Information:
ShmMax ShmMin ShmIds ShmSeg
68719476736 1 131072 0

Semaphore Information:
SemMap SemMni SemMns SemMnu SemMsl SemOpm SemUme SemUsz SemVmx SemAem
n/a 131072 n/a n/a 65535 1024 n/a n/a 32767 16384

CPU Load Information:
Short Medium Long
1.386337 1.206024 1.345779

CPU Usage Information (percent):
Total Usr Sys Wait Idle
4.166667 0.277778 3.750000 0.138889 95.833333

Database Configuration for Database DATA

Database configuration release level = 0x0d00
Database release level = 0x0d00

Database territory = RU
Database code page = 915
Database code set = ISO8859-5
Database country/region code = 7
Database collating sequence = UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 32768

Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE

Statement concentrator (STMT_CONC) = OFF

Discovery support for this database (DISCOVER_DB) = ENABLE

Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20

Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN

Backup pending = NO

All committed transactions have been written to disk = NO
Rollforward pending = DATABASE
Restore pending = NO

Multi-page file allocation enabled = YES

Log retain for recovery status = NO
User exit for logging status = YES

Self tuning memory (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB) (DATABASE_MEMORY) = 10000
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = 458572
Percent. of lock lists per application (MAXLOCKS) = 97
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(5216)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 3938372
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(256)

Database heap (4KB) (DBHEAP) = AUTOMATIC(262140)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 10600
Log buffer size (4KB) (LOGBUFSZ) = 256
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(4096)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)

Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = 10800

Changed pages threshold (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(47)
Number of I/O servers (NUM_IOSERVERS) = 8
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC

Track modified pages (TRACKMOD) = ON

Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32

Max number of active applications (MAXAPPLS) = AUTOMATIC(652)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application (MAXFILOP) = 61440

Log file size (4KB) (LOGFILSIZ) = 65535
Number of primary log files (LOGPRIMARY) = 12
Number of secondary log files (LOGSECOND) = -1
Changed path to log files (NEWLOGPATH) =
Path to log files = /NODE0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0354097.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 200

Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF

HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0

First log archive method (LOGARCHMETH1) = DISK:/archlog/
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) = /fail/
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =

Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF

TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =

Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = ON

Auto-Revalidation (AUTO_REVAL) = DEFERRED
Currently Committed (CUR_COMMIT) = ON
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = EXTENDED
Activity metrics (MON_ACT_METRICS) = EXTENDED
Object metrics (MON_OBJ_METRICS) = BASE
Unit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1

SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE