Home Database Mysql Tutorial DB2报SQLEX_UNEXPECTED_SYSERR错误解决

DB2报SQLEX_UNEXPECTED_SYSERR错误解决

Jun 07, 2016 pm 04:48 PM
db db2

偶然发现自己的DB2测试环境无法使用,打开老是报错,之前一直以为是db2audit报错

偶然发现自己的DB2测试环境无法使用,打开老是报错,之前一直以为是db2audit报错

DB2数据库性能调整和优化(第1、2版) PDF

DB2数据库性能优化介绍

DB2  9.7 for Linux 5.4安装详细步骤

2013-12-19-23.19.10.388418+480 E829168G1400      LEVEL: Event
PID    : 6743                TID  : 3054496656  PROC : db2syscr
INSTANCE: db2inst1            NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START  : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09075"
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23291", Fix Pack "5".
DATA #2 : System Info, 436 bytes
System: Linux marven 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:1011 free:161
Virtual  Memory(MB): total:3059 free:2209
Swap    Memory(MB): total:2048 free:2048
Kernel  Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024
                msgNumberOfHeaders:65536 msgMaxQueueSize:65536
                msgMaxSegmentSize:16 shmMax:1059983360 shmMin:1 shmIDs:4096
                shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000
                semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
                semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds)  = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes)  = 0xFFFFFFFF
Cur stack size (bytes)  = 0x00A00000
Cur core size (bytes)  = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors)  = 0x00000800

2013-12-19-21.35.24.548881+480 I1899G343          LEVEL: Error
PID    : 5979                TID  : 3050367200  PROC : db2set
INSTANCE: db2inst1            NODE : 000
FUNCTION: DB2 UDB, bsu security, sqlexAuditGetNodeNum, probe:13176
MESSAGE : ZRC=0x070F00B8=118423736=SQLO_NOT_FOUND
          "Environment/registry variable was not found."

2013-12-19-23.08.04.323645+480 I733636G904        LEVEL: Error
PID    : 6306                TID  : 3050825424  PROC : db2fm
INSTANCE: db2inst1            NODE : 000
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C=-1879047540=ECF_GCF_GCF_FUNCTION_TIMED_OUT
          Timeout occured while calling a GCF interface function
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0xB7D19809 /opt/ibm/db2/V9.7/lib32/libdb2osse.so.1 + 0xBE809
  [1] 0xB7D1AA78 ossLog + 0x96
  [2] 0xB7C0F249 _ZN9GcfCaller8getStateEP12GCF_PartInfojP11GCF_RetInfo + 0x7D
  [3] 0x0804C385 main + 0xBE1
  [4] 0x00299E9C __libc_start_main + 0xDC
  [5] 0x0804B721 __gxx_personality_v0 + 0x111
  [6] 0x00000000 ?unknown + 0x0
  [7] 0x00000000 ?unknown + 0x0
  [8] 0x00000000 ?unknown + 0x0
  [9] 0x00000000 ?unknown + 0x0

2013-12-19-23.08.04.324035+480 I734541G1101      LEVEL: Error
PID    : 6306                TID  : 3050825424  PROC : db2fm
INSTANCE: db2inst1            NODE : 000
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292=-1879047534=ECF_GCF_SERVICE_FUNCTION_FAILED
          The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298=-1879047528=ECF_GCF_FAILURE
          Failure as reported through GCF standard (GCF_FAILURE)
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0xB7D19809 /opt/ibm/db2/V9.7/lib32/libdb2osse.so.1 + 0xBE809
  [1] 0xB7D1A94D ossLogRC + 0x4F
  [2] 0xB7C0F29F _ZN9GcfCaller8getStateEP12GCF_PartInfojP11GCF_RetInfo + 0xD3
  [3] 0x0804C385 main + 0xBE1
  [4] 0x00299E9C __libc_start_main + 0xDC
  [5] 0x0804B721 __gxx_personality_v0 + 0x111
  [6] 0x00000000 ?unknown + 0x0
  [7] 0x00000000 ?unknown + 0x0
  [8] 0x00000000 ?unknown + 0x0
  [9] 0x00000000 ?unknown + 0x0

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Repo: How To Revive Teammates
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Comparative analysis of Oracle and DB2 database technology Comparative analysis of Oracle and DB2 database technology Mar 11, 2024 am 09:54 AM

Oracle and DB2 are two well-known relational database management systems (RDBMS) that are widely used in enterprise applications. In this article, we will compare the two database technologies of Oracle and DB2 and analyze them in detail, including analysis of their characteristics, performance, functions and usage examples. 1. Overview of Oracle database technology Oracle is a relational database management system developed by Oracle Corporation of the United States. It is widely used in enterprise-level applications and has strong performance and stability.

Comparison and differences of SQL syntax between Oracle and DB2 Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

Comparative analysis of Oracle and DB2 database performance Comparative analysis of Oracle and DB2 database performance Mar 09, 2024 pm 10:00 PM

Oracle and DB2 databases are two leading relational database management systems that are widely used in enterprise-level applications. In practical applications, database performance is often one of the important indicators for evaluating the quality of a database system. This article will conduct a comparative analysis of the performance of Oracle and DB2 databases, and use specific code examples to demonstrate the differences between them. 1. Oracle database performance analysis Oracle database is a powerful database management system with good scalability and stability.

What file format is db? What file format is db? May 19, 2021 am 11:56 AM

db is the abbreviation of "datebase", which is a format of "database file". It is a file used by software to store data, which is equivalent to a database. Each software has its own storage format. For example, "Thumbs.db" under Win7 system is a thumbnail data file, so the db file is not a specific file format.

What is the difference between db2 and oracle syntax What is the difference between db2 and oracle syntax Jul 05, 2023 am 10:39 AM

Differences in syntax between db2 and oracle: 1. SQL syntax differences. Although db2 and oracle both use structured query language, they have some differences in syntax; 2. db2 and oracle have different data types; 3. Foreign key constraint definition, db2 can be defined when creating the table or added after using the "ALTER TABLE" statement. Oracle needs to be defined together when creating the table; 4. There are also some differences in the syntax of db2 and oracle stored procedures and functions.

Comparison of features between Oracle and DB2 database management systems Comparison of features between Oracle and DB2 database management systems Mar 11, 2024 am 08:57 AM

Oracle and DB2 are two common relational database management systems, each with their own unique characteristics and advantages. This article will compare the characteristics of Oracle and DB2, and provide specific code examples to illustrate the differences between them. 1. Characteristics of Oracle database management system: Storage engine: Oracle database uses its own unique storage engine, called Oracle Database Engine (OracleDatabaseEngine), which can handle large-scale data storage.

What is the file format of db? What is the file format of db? Mar 07, 2023 pm 05:27 PM

db is a database file format, which is a file used by software to store data. It is equivalent to a database. Each software has its own storage format, that is, the way the data is arranged; the suffix of some software data files is DB. For example, Thumbs.db under Win7 system is a thumbnail data file; therefore, the db file is not a specific file format.

MySQL to DB2: How to automate data migration and conversion? MySQL to DB2: How to automate data migration and conversion? Sep 08, 2023 am 08:22 AM

MySQL to DB2: How to automate data migration and conversion? Introduction: With the continuous development of information technology, many enterprises need to migrate databases from one platform to another. This article will focus on how to realize the automated process of database migration and data conversion from MySQL to DB2. 1. Solution selection and preparation: Before starting automated data migration and transformation, we need to make some choices and preparations. Choose the right migration tool: There are many data migration tools to choose from, such as IBM’s Data

See all articles