Topic
4 replies Latest Post - ‏2008-12-23T08:13:59Z by dickr
SANSAN
SANSAN
2 Posts
ACCEPTED ANSWER

Pinned topic DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004-4294966254

‏2008-05-01T14:50:45Z |
Friends,

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.

Help is highly appriciated. Thanks in advance.
Updated on 2008-12-23T08:13:59Z at 2008-12-23T08:13:59Z by dickr
  • SANSAN
    SANSAN
    2 Posts
    ACCEPTED ANSWER

    Re: DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004-4294966254

    ‏2008-05-01T15:05:45Z  in response to SANSAN
    Few more details, for you guys to understand the problem.
    <hr />
    C:\Documents and Settings\Administrator>db2set -all
    [e] DB2PATH=C:\Program Files\IBM\SQLLIB
    DB2ACCOUNTNAME=OCS0357\admin
    DB2INSTOWNER=OCS0357
    DB2PORTRANGE=50001:50004
    DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=OCS0357
    [g] DB2PATH=C:\Program Files\IBM\SQLLIB
    [g] DB2ADMINSERVER=DB2DAS00

    C:\Documents and Settings\Administrator>
    <hr />
    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>
    -------------------------------------------------------------
    • mspurloc@logisys911.com
      10 Posts
      ACCEPTED ANSWER

      Re: DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004-4294966254

      ‏2008-12-17T22:03:12Z  in response to SANSAN
      If you upgrade to or beyond 8.1 Fix Pack 16, does the problem go away?
  • dickr
    dickr
    57 Posts
    ACCEPTED ANSWER

    Re: DB2-SQL1042C An unexpected system error occurred.SQLSTATE=58004-4294966254

    ‏2008-12-23T08:13:59Z  in response to SANSAN
    Join the club: http://www.ibm.com/developerworks/forums/thread.jspa?threadID=202813&tstart=200