Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    56

    Unhappy Unanswered: Restore / Migrate serious issue URGENT

    Hi,

    I have a production server AIX 5.3 running DB2 v8.2.9.
    One database running and I am trying to restore a second one into this server.
    I have a failover box that has those 2 databases working without any problems;
    ---------------
    I am trying to restore the very same 7.1 backup into the production box, like I did for the second one successfuly, and it is failing due to memory problems.
    Here is what I am getting during both restore and db2 migrate utility:
    ============
    2008-06-26-12.39.09.098358-300 I20277786C258 LEVEL: Warning
    PID : 125458 TID : 1 PROC : db2bp
    INSTANCE: db2hawk NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:1
    MESSAGE : Begin engn migration

    2008-06-26-12.39.17.525150-300 I20278045C952 LEVEL: Severe
    PID : 103648 TID : 1 PROC : db2agent (FACILITY) 0
    INSTANCE: db2hawk NODE : 000 DB : FACILITY
    APPHDL : 0-1342 APPID: *LOCAL.db2hawk.080626173909
    FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:21
    MESSAGE : Failed to allocate App Ctl Shr Mem Set with follwing error. Reduce
    APPGROUP_MEM_SZ. On 32bit AIX, this problem may also happen when the
    DB memory set is too big that it spills over to the APPGROUP memory
    address. Try reducing the DB memory size by using smaller
    bufferpool(s), or reducing the values for the database configuration
    parameters that affect the size of the DB memory such as DBHEAP,
    CATALOGCACHE_SZ, LOCKLIST, PCKCACHESZ, etc...
    DATA #1 : Hexdump, 4 bytes
    0x2FF1920C : 850F 0005 ....

    2008-06-26-12.39.17.525737-300 I20278998C496 LEVEL: Severe
    PID : 103648 TID : 1 PROC : db2agent (FACILITY) 0
    INSTANCE: db2hawk NODE : 000 DB : FACILITY
    APPHDL : 0-1342 APPID: *LOCAL.db2hawk.080626173909
    FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:20
    RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
    "No Storage Available for allocation"
    DIA8305C Memory allocation failure occurred.

    2008-06-26-12.39.18.529706-300 I20279495C489 LEVEL: Severe
    PID : 103648 TID : 1 PROC : db2agent (idle) 0
    INSTANCE: db2hawk NODE : 000 DB : FACILITY
    APPHDL : 0-1342 APPID: *LOCAL.db2hawk.080626173909
    FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:140
    RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
    "No Storage Available for allocation"
    DIA8305C Memory allocation failure occurred.

    2008-06-26-12.39.18.531335-300 I20279985C290 LEVEL: Warning
    PID : 125458 TID : 1 PROC : db2bp
    INSTANCE: db2hawk NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:2
    MESSAGE : End engn migration: with rc = -1042, sqlcode = -1042

    ================
    The database that I am trying to restore, it is running as production in a old AIX 4.3 server with DB2 v7.1.0.

    And has the following db cfg for version 7.1.0

    db2fudd@fudd:/db2bkups/bkup1:>db2 get db cfg for facility

    Database Configuration for Database facility

    Database configuration release level = 0x0900
    Database release level = 0x0900

    Database territory = US
    Database code page = 850
    Database code set = IBM-850
    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) = 2
    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 = YES
    Rollforward pending = NO
    Restore pending = NO

    Multi-page file allocation enabled = NO

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

    Data Links Token Expiry Interval (sec) (DL_EXPINT) = 1
    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) = 4000
    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 1926
    Log buffer size (4KB) (LOGBUFSZ) = 96
    Utilities heap size (4KB) (UTIL_HEAP_SZ) = 7680
    Buffer pool size (pages) (BUFFPAGE) = 225000
    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) = 40000

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

    Sort list heap (4KB) (SORTHEAP) = 1024
    SQL statement heap (4KB) (STMTHEAP) = 6144
    Default application heap (4KB) (APPLHEAPSZ) = 384
    Package cache size (4KB) (PCKCACHESZ) = 4000
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 6400

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

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

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

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

    Log file size (4KB) (LOGFILSIZ) = 4000
    Number of primary log files (LOGPRIMARY) = 6
    Number of secondary log files (LOGSECOND) = 10
    Changed path to log files (NEWLOGPATH) =
    Path to log files = /dblogs/emcfac/
    First active log file = S0010732.LOG

    Group commit count (MINCOMMIT) = 1
    Percent log file reclaimed before soft chckpt (SOFTMAX) = 80
    Log retain for recovery enabled (LOGRETAIN) = RECOVERY
    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) =
    =====



    I need to have this fixed because PRETTY SOON I will have to deploy this old database into this server (production) and I can't do it.

    Could anyone help me please??

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    My first idea would have been to do what the 2nd message describes:
    MESSAGE : Failed to allocate App Ctl Shr Mem Set with follwing error. Reduce
    APPGROUP_MEM_SZ. On 32bit AIX, this problem may also happen when the
    DB memory set is too big that it spills over to the APPGROUP memory
    address. Try reducing the DB memory size by using smaller
    bufferpool(s), or reducing the values for the database configuration
    parameters that affect the size of the DB memory such as DBHEAP,
    CATALOGCACHE_SZ, LOCKLIST, PCKCACHESZ, etc...
    Have you tried that?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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