Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2003
    Posts
    11

    Unanswered: System memory limit maxed

    Hi,
    I am a new user to this group. I am working on db2v7.2, aix5.1. I am posting a part of the db2diag.log file.

    2003-07-14-08.31.54.288036 Instance:db2inst2 Node:000
    PID:17004(db2agent ) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_dump_ffdc Probe:902 Database:
    DIA3833C The system memory limit was reached.

    ZRC=FFFFF624

    The system is configured to have around 3.3G RAM and about 7G virtual memory. Hence i am confused with this error.

    Also when i shutdown and start the ArcSDE instance i get the following error message:

    SQL1131N DARI (Stored Procedure) process has been terminated abnormally.SQLSTATE=38503

    I have done a "db2 force application all "command on the database.in the past. I am not sure whether that has caused an error. I dont know where to check .
    Any help will be truly appreciated.
    asasidar

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What is the size of your DB2 buffer pools? DB2 wants real memory for these.

  3. #3
    Join Date
    Jul 2003
    Posts
    11

    db2 buffer pool

    Hi,
    The SYSIBM.SYSBUFFEPOOLS = 330000 pages while the buffer pool size in the cofigure parameters is 524288. Right now there is only a single bufferpool allocated to the database.

    Thanks,
    asasidar

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    I'm not sure if this is how you're supposed to read it but FFFFF624 does correspond to a bad configuration file according to Appendix A of the Troubleshooting Guide : DB2 Internal Return Codes.

  5. #5
    Join Date
    Jul 2003
    Posts
    11

    bad configuration file

    Hi,
    Is there any way to fix a bad configuration file?
    I have configured the datbase only through the GUI. Is there any other
    way?


    Thanks,
    asasidar

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: bad configuration file

    Maybe you need to post a few more db2diag.log messages, before and after this error ... May be there is a clue ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Jul 2003
    Posts
    11

    more of the db2diag.log file

    Hi,
    The following is some more of the db2diag.log file.
    Thanks for your help.



    2003-07-14-08.31.53.899657 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    global_services sqlzerdm Probe:40 Database:PKILC

    ffff f624 $


    2003-07-14-08.31.53.982576 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_signal_handler Probe:10 Database:PKILC
    DIA7107I Execution of a component signal handling function has begun.

    2003-07-14-08.31.54.001252 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_signal_handler Probe:20 Database:PKILC
    DIA7108I Execution of a component signal handling function is complete.

    2003-07-14-08.31.54.019232 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_dump_ffdc Probe:17 Database:PKILC
    DIA3833C The system memory limit was reached.

    2003-07-14-08.31.54.037097 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_dump_ffdc Probe:17 Database:PKILC
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFFF624".


    String Title:locklist PID:17004 Node:000
    Check /home/db2inst2/sqllib/db2dump/l12783.000 for additional data.

    2003-07-14-08.31.55.615204 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrrdi Probe:120 Database:PKILC

    ffff f624 $


    Data Title:rc_flags: PID:17004 Node:000
    0400 0040 ...@


    2003-07-14-08.31.55.740095 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqleflsr Probe:1 Database:PKILC

    DiagData
    0400 0140 ...@


    2003-07-14-08.31.55.829754 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqleflsr Probe:1 Database:PKILC

    RIDS/sqleflsr MS/DB_BAD_FAT PRCS/10400 0140 ...@


    2003-07-14-08.31.55.925639 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqleflsr Probe:2 Database:PKILC

    DiagData
    5351 4c43 4120 2020 0000 0088 ffff fc7a SQLCA ....z
    0002 3336 2020 2020 2020 2020 2020 2020 ..36
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 7371 6c72 6163 6669 sqlracfi
    ffff f624 0000 0024 0000 0000 0000 0000 $...$........
    0000 0000 0000 0000 2020 2020 2020 2020 ........
    2020 2020 2020 2020


    2003-07-14-08.31.56.158341 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqleflsr Probe:2 Database:PKILC

    RIDS/sqleflsr MS/DB_BAD_FAT PRCS/25351 4c43 4120 2020 0000 0088 ffff fc7a SQLCA ....z
    0002 3336 2020 2020 2020 2020 2020 2020 ..36
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 2020 2020 2020 2020
    2020 2020 2020 2020 7371 6c72 6163 6669 sqlracfi
    ffff f624 0000 0024 0000 0000 0000 0000 $...$........
    0000 0000 0000 0000 2020 2020 2020 2020 ........
    2020 2020 2020 2020


    String Title:sqleMarkDBad: PID:17004 Node:000
    Marking the database bad.

    2003-07-14-08.31.56.419682 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_signal_handler Probe:10 Database:PKILC
    DIA7107I Execution of a component signal handling function has begun.

    2003-07-14-08.31.56.439222 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    relation_data_serv sqlrr_signal_handler Probe:20 Database:PKILC
    DIA7108I Execution of a component signal handling function is complete.

    2003-07-14-08.31.56.457241 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqlesrsp Probe:9 Database:PKILC

    2003-07-14-08.31.56.546756 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqlesrsp Probe:9 Database:PKILC

    RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9ffff fbf6


    2003-07-14-08.31.56.642667 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    buffer_pool_services sqlbTerminateAgent Probe:837 Database:PKILC
    DIA3727C The database has been marked as being damaged.

    ZRC=FFFFE11A

    2003-07-14-08.31.56.714102 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714132856
    base_sys_utilities sqleTermDbConnect Probe:5 Database:PKILC
    DIA3727C The database has been marked as being damaged.

    ZRC=FFFFE11A

    2003-07-14-08.32.14.017447 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714133213
    base_sys_utilities sqledint Probe:0 Database:PKILC

    Crash Recovery is needed.

    2003-07-14-08.32.18.281024 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714133213
    recovery_manager sqlpresr Probe:1 Database:PKILC
    DIA3908W Crash recovery has been initiated. Lowtran LSN is "00006C66000C",
    Minbuff LSN is "00006C66000C".

    2003-07-14-08.32.18.301519 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714133213
    recovery_manager sqlprecm Probe:125 Database:PKILC

    Using parallel recovery with 3 agents 7 QSets 49 queues and 2 chunks


    2003-07-14-08.32.18.564838 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714133213
    recovery_manager sqlprecm Probe:400 Database:PKILC
    DIA3916W Forward phase of crash recovery has completed. Next LSN is
    "00006C661734".

    2003-07-14-08.32.18.601773 Instance:db2inst2 Node:000
    PID:17004(db2agent (PKILC)) Appid:*LOCAL.db2inst2.030714133213
    recovery_manager sqlpresr Probe:170 Database:PKILC
    DIA3909W Crash recovery completed. Next LSN is "00006C661734".

  8. #8
    Join Date
    Mar 2003
    Posts
    343
    It appears that your database is corrupted and has been marked bad. However, it does not mention why. Do you have a filesystem backup of the database directory?

    Also, read up the administration guide about the bufferpools - if you have do not have -1 in one of them (between syscat.bufferpools and the buffpage), on overrides the other. So at this point you need to determine which one it is trying to allocate.
    Also can you post the dbm and db cfgs?

  9. #9
    Join Date
    Jul 2003
    Posts
    11

    dbm & db cfg

    Hi,
    Database Configuration for Database
    Database configuration release level = 0x0900
    Database release level = 0x0900
    Database territory = us
    Database code page = 1252
    Database code set = IBM-1252
    Database country code = 1
    Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE

    Directory object name (DIR_OBJ_NAME) =
    Discovery support for this database (DISCOVER_DB) = ENABLE

    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
    Number of frequent values retained (NUM_FREQVALUES) = 10
    Number of quantiles retained (NUM_QUANTILES) = 20

    Backup pending = NO

    Database is consistent = NO
    Rollforward pending = NO
    Restore pending = NO

    Multi-page file allocation enabled = NO

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

    Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
    Data Links Number of Copies (DL_NUM_COPIES) = 1
    Data Links Time after Drop (days) (DL_TIME_DROP) = 1
    Data Links Token in Uppercase (DL_UPPER) = NO
    Data Links Token Algorithm (DL_TOKEN) = MAC0

    Database heap (4KB) (DBHEAP) = 1658
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 370
    Log buffer size (4KB) (LOGBUFSZ) = 32
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 64000
    Buffer pool size (pages) (BUFFPAGE) = 524288
    Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
    Number of extended storage segments (NUM_ESTORE_SEGS) = 0
    Max storage for lock list (4KB) (LOCKLIST) = 881

    Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 2048

    Sort list heap (4KB) (SORTHEAP) = 2658
    SQL statement heap (4KB) (STMTHEAP) = 2048
    Default application heap (4KB) (APPLHEAPSZ) = 2048
    Package cache size (4KB) (PCKCACHESZ) = 800
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

    Interval for checking deadlock (ms) (DLCHKTIME) = 10000
    Percent. of lock lists per application (MAXLOCKS) = 18
    Lock timeout (sec) (LOCKTIMEOUT) = -1

    Changed pages threshold (CHNGPGS_THRESH) = 60
    Number of asynchronous page cleaners (NUM_IOCLEANERS) = 5
    Number of I/O servers (NUM_IOSERVERS) = 7
    Index sort flag (INDEXSORT) = YES
    Sequential detect flag (SEQDETECT) = YES
    Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32

    Track modified pages (TRACKMOD) = OFF

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

    Max number of active applications (MAXAPPLS) = 100
    Average number of active applications (AVG_APPLS) = 1
    Max DB files open per application (MAXFILOP) = 64

    Log file size (4KB) (LOGFILSIZ) = 1000
    Number of primary log files (LOGPRIMARY) = 6
    Number of secondary log files (LOGSECOND) = 10
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /home/db2inst2/db2inst2/NODE0000/SQL00003/SQLOGDIR/
    First active log file =

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

    Auto restart enabled (AUTORESTART) = ON
    Index re-creation time (INDEXREC) = SYSTEM (RESTART)
    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

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

    Database Manager Configuration
    Node type = Database Server with local and remote clients
    Database manager configuration release level = 0x0900
    CPU speed (millisec/instruction) (CPUSPEED) = 5.550044e-07
    Max number of concurrently active databases (NUMDB) = 8
    Data Links support (DATALINKS) = NO
    Federated Database System Support (FEDERATED) = YES
    Transaction processor monitor name (TP_MON_NAME) =

    Default charge-back account (DFT_ACCOUNT_STR) =

    Java Development Kit 1.1 installation path (JDK11_PATH) =
    Diagnostic error capture level (DIAGLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) = /home/db2inst2/sqllib/db2dump

    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = OFF
    Lock (DFT_MON_LOCK) = OFF
    Sort (DFT_MON_SORT) = OFF
    Statement (DFT_MON_STMT) = OFF
    Table (DFT_MON_TABLE) = OFF
    Unit of work (DFT_MON_UOW) = OFF

    SYSADM group name (SYSADM_GROUP) = DB2IADM2
    SYSCTRL group name (SYSCTRL_GROUP) =
    SYSMAINT group name (SYSMAINT_GROUP) =
    Database manager authentication (AUTHENTICATION) = SERVER_ENCRYPT
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Default database path (DFTDBPATH) = /home/db2inst2
    Database monitor heap size (4KB) (MON_HEAP_SZ) = 56
    UDF shared memory set size (4KB) (UDF_MEM_SZ) = 2560
    Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
    Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
    Backup buffer default size (4KB) (BACKBUFSZ) = 1024
    Restore buffer default size (4KB) (RESTBUFSZ) = 1024
    Sort heap threshold (4KB) (SHEAPTHRES) = 20000
    Directory cache support (DIR_CACHE) = YES
    Application support layer heap size (4KB) (ASLHEAPSZ) = 15
    Max requester I/O block size (bytes) (RQRIOBLK) = 32767
    Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
    DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128
    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 200
    Agent pool size (NUM_POOLAGENTS) = 4 (calculated)
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of logical agents (MAX_LOGICAGENTS) = MAX_COORDAGENTS
    Keep DARI process (KEEPDARI) = YES
    Max number of DARI processes (MAXDARI) = MAX_COORDAGENTS
    Initialize DARI process with JVM (INITDARI_JVM) = NO
    Initial number of fenced DARI process (NUM_INITDARIS) = 0
    Index re-creation time (INDEXREC) = RESTART
    Transaction manager database name (TM_DATABASE) = 1ST_CONN
    Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

    SPM name (SPM_NAME) = LCGnet
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =

    TCP/IP Service name (SVCENAME) = db2cdb2inst10
    APPC Transaction program name (TPNAME) =
    IPX/SPX File server name (FILESERVER) =
    IPX/SPX DB2 server object name (OBJECTNAME) =
    IPX/SPX Socket number (IPX_SOCKET) = 879E

    Discovery mode (DISCOVER) = SEARCH
    Discovery communication protocols (DISCOVER_COMM) = TCPIP
    Discover server instance (DISCOVER_INST) = ENABLE

    Directory services type (DIR_TYPE) = NONE
    Directory path name (DIR_PATH_NAME) = /.:/subsys/database/
    Directory object name (DIR_OBJ_NAME) =
    Routing information object name (ROUTE_OBJ_NAME) =
    Default client comm. protocols (DFT_CLIENT_COMM) =

    Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
    Enable intra-partition parallelism (INTRA_PARALLEL) = NO

    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
    Number of FCM request blocks (FCM_NUM_RQB) = 512
    Number of FCM connection entries (FCM_NUM_CONNECT) = (FCM_NUM_RQB * 0.75)
    Number of FCM message anchors (FCM_NUM_ANCHORS) = (FCM_NUM_RQB * 0.75)

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •