Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008

    Question Unanswered: DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004 -Start DB2 4294966254


    We were having an application was running on DB2 8.1 with Fixpack 6. Till then, was running good. When people installed Fixpak 7, unable to start the Server Instance or connect to the Database from Websphere v5.1(Data Source-> TestConnection)/Java code.

    Following ways, i have tried to start/connect the DB2.

    1. Tried to connect to the Database from Control Center on the same server machine as well as from my desktop. Same Error message "SQL1042C An unexpected system error occurred.SQLSTATE=58004".

    2. Tried to connect to the database from the command line in the server instance. Getting same error "SQL1042C An unexpected system error occurred.SQLSTATE=58004"

    3. In Services (My Computer(Right Click)->Manage->Services->DB2 - DB2(Right Click)-> Start), Getting the error message as like "The DB2 - DB2 service terminated with service-specific error 4294966254". I have verified the service called "Server" running and Net BIOS over TCP/IP is enabled.

    4. When i search with "SQL1042C An unexpected system error occurred.SQLSTATE=58004" in IBM site, they asked to drop instance and re-create. I tried. But,No use. Same error - SQL1042C.

    Few more details, for you guys to understand the problem.

    C:\Documents and Settings\Administrator>db2set -all
    [e] DB2PATH=C:\Program Files\IBM\SQLLIB
    [g] DB2SYSTEM=OCS0357
    [g] DB2PATH=C:\Program Files\IBM\SQLLIB

    C:\Documents and Settings\Administrator>

    C:\Documents and Settings\Administrator>db2 get dbm cfg

    Database Manager Configuration

    Node type = Enterprise Server Edition with local and remote clients

    Database manager configuration release level = 0x0a00

    Maximum total of files open (MAXTOTFILOP) = 16000
    CPU speed (millisec/instruction) (CPUSPEED) = 2.834065e-007
    Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+002

    Max number of concurrently active databases (NUMDB) = 8
    Data Links support (DATALINKS) = NO
    Federated Database System Support (FEDERATED) = NO
    Transaction processor monitor name (TP_MON_NAME) =

    Default charge-back account (DFT_ACCOUNT_STR) =

    Java Development Kit installation path (JDK_PATH) = C:\PROGRA~1\IBM\SQLLIB\java\jdk

    Diagnostic error capture level (DIAGLEVEL) = 3
    Notify Level (NOTIFYLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) =

    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
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = OFF
    Monitor health of instance and databases (HEALTH_MON) = ON

    SYSADM group name (SYSADM_GROUP) =
    SYSCTRL group name (SYSCTRL_GROUP) =
    SYSMAINT group name (SYSMAINT_GROUP) =
    SYSMON group name (SYSMON_GROUP) =

    Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
    Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
    Group Plugin (GROUP_PLUGIN) =
    GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
    Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
    Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
    Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Database manager authentication (AUTHENTICATION) = SERVER
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Bypass federated authentication (FED_NOAUTH) = NO

    Default database path (DFTDBPATH) = C:

    Database monitor heap size (4KB) (MON_HEAP_SZ) = 66
    Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 512
    Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
    Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
    Backup buffer default size (4KB) (BACKBUFSZ) = 1024
    Restore buffer default size (4KB) (RESTBUFSZ) = 1024

    Agent stack size (AGENT_STACK_SZ) = 16
    Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
    Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000

    Sort heap threshold (4KB) (SHEAPTHRES) = 10000

    Directory cache support (DIR_CACHE) = YES

    Application support layer heap size (4KB) (ASLHEAPSZ) = 15
    Max requester I/O block size (bytes) (RQRIOBLK) = 32767
    DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096
    Query heap size (4KB) (QUERY_HEAP_SZ) = 1000

    Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 200
    Agent pool size (NUM_POOLAGENTS) = 100(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 client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS

    Keep fenced process (KEEPFENCED) = YES
    Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
    Initial number of fenced processes (NUM_INITFENCED) = 0

    Index re-creation time and redo index build (INDEXREC) = RESTART

    Transaction manager database name (TM_DATABASE) = 1ST_CONN
    Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

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

    NetBIOS Workstation name (NNAME) =

    TCP/IP Service name (SVCENAME) =
    Discovery mode (DISCOVER) = SEARCH
    Discover server instance (DISCOVER_INST) = ENABLE

    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) = AUTOMATIC
    Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
    Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC

    Node connection elapse time (sec) (CONN_ELAPSE) = 10
    Max number of node connection retries (MAX_CONNRETRIES) = 5
    Max time difference between nodes (min) (MAX_TIME_DIFF) = 60

    db2start/db2stop timeout (min) (START_STOP_TIME) = 10

    C:\Documents and Settings\Administrator>

    Help is highly appriciated. Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    What's in db2diag.log?
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    Two more questions from my side:
    (1) Do you have any particular reason not to install the latest DB2 V8 FixPak and stick with the rather old FP7?
    (2) Have you followed all the steps listed in the readme that accompanies the FP?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    May 2008

    Thumbs up Thanks a lot Guys

    Ya. I tried to install the latest patches of DB2 8.1 till 16th patch.

    That got resolved the issue. and spoke to IBM DB2 people also. Seems, Patch compatible issue it is.

    Thanks a lot guys.

Posting Permissions

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