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 installation path (JDK_PATH) = /usr/java13_64
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) = DB2GRP1
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) =
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
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) = 200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
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
TCP/IP Service name (SVCENAME) = db2c_db2udbp
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) = 4096
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
db2实例用户是db2udbp
实例可以启动:
myhost#su - db2udbp
myhost/home/db2udbp$db2start
03/18/2005 22:12:30 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
但是连接不上数据库mydb
myhost/home/db2udbp$db2 connect to mydb
SQL30082N Attempt to establish connection failed with security reason "3"
("ASSWORD MISSING". SQLSTATE=08001
不知道为什么现在实例用户也必须要输入密码了???(同事说几天前就这样了)
输入密码后报30081N错误
myhost/home/db2udbp$db2 connect to mydb user db2udbp using xxxxxx
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "10.1.1.1". Communication function detecting
the error: "recv". Protocol specific error code(s): "*", "*", "0".
SQLSTATE=08001
myhost/home/db2udbp$
msn: cyber_flying@hotmail.com
qq: 19464332作者: myuhan 时间: 2005-03-19 09:39 标题: 求救: SQL30081N错误,数据库实例可启动,但是不能连接数据库 等下有时间帮你查查,应该不需要密码,那你加上user db2udbp using pass 看看呢作者: 咖喱猫 时间: 2005-03-19 10:02 标题: 求救: SQL30081N错误,数据库实例可启动,但是不能连接数据库 使用db2 connect to dbname user dbuser using dbpass可以的。
db2 list db directory 显示是什么?作者: cyberflying 时间: 2005-03-19 13:17 标题: 求救: SQL30081N错误,数据库实例可启动,但是不能连接数据库 多谢两位关注!
加上密码后就报了SQL30081N的错误了啊!
db2 list db directory显示的信息如下:
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = mydb
Database name = mydb
Node name = NDE9EF20
Database release level = a.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =