更多

查看: 3432|回复: 7

帮忙看看，什么问题 [复制链接]

anlinew

版主

按妞

精华贴数: 6
技术积分: 12275
社区积分: 436
注册时间: 2002-11-4

论坛徽章:: 43

发表于 2007-5-28 12:53:00 |显示全部楼层

[PHP]cw550[/]#tail -n 200 /home/db2inst1/sqllib/db2dump/db2diag.log
2007-05-18-11.58.53.086591+480 E15210202A369    LEVEL: Error (OS)
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.53.086876+480 I15210572A305    LEVEL: Severe
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.53.087098+480 E15210878A369    LEVEL: Error (OS)
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.53.087372+480 I15211248A305    LEVEL: Severe
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.53.087597+480 E15211554A369    LEVEL: Error (OS)
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.53.087873+480 I15211924A305    LEVEL: Severe
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.53.088194+480 E15212230A369    LEVEL: Error (OS)
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.53.088491+480 I15212600A305    LEVEL: Severe
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.53.088713+480 E15212906A369    LEVEL: Error (OS)
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.53.088989+480 I15213276A305    LEVEL: Severe
PID    : 282790             TID  : 11376    PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O094.0801F5120749
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.55.175343+480 E15213582A369    LEVEL: Error (OS)
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.55.175877+480 I15213952A305    LEVEL: Severe
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.55.190031+480 E15214258A369    LEVEL: Error (OS)
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.55.190396+480 I15214628A305    LEVEL: Severe
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-11.58.55.190628+480 E15214934A369    LEVEL: Error (OS)
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, oper system services, sqloxltc_app, probe:15
CALLED  : OS, -, unspecified_system_function
OSERR : EINVAL (22) "系统调用接收到无效的参数。"

2007-05-18-11.58.55.190903+480 I15215304A305    LEVEL: Severe
PID    : 201046             TID  : 8227       PROC : java
INSTANCE: db2inst1          NODE : 000
APPID : GAA50114.O07A.01E645120719
FUNCTION: DB2 UDB, base sys utilities, sqleAttachCtx, probe:10
RETCODE : ZRC=0x83000016=-2097151978

2007-05-18-12.15.56.323075+480 E15215610A385    LEVEL: Warning (OS)
PID    : 163850             TID  : 8759       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 17 bytes
/BigData/db2inst1

2007-05-18-12.15.56.323984+480 E15215996A385    LEVEL: Warning (OS)
PID    : 163850             TID  : 8759       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 17 bytes
/BigData/db2inst1

2007-05-18-12.15.56.324319+480 E15216382A392    LEVEL: Warning (OS)
PID    : 163850             TID  : 8759       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 24 bytes
/BigData/ufsoft/db2inst1

2007-05-18-12.16.12.931565+480 E15216775A385    LEVEL: Warning (OS)
PID    : 307360             TID  : 8225       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 17 bytes
/BigData/db2inst1

2007-05-18-12.16.12.932290+480 E15217161A385    LEVEL: Warning (OS)
PID    : 307360             TID  : 8225       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 17 bytes
/BigData/db2inst1

2007-05-18-12.16.12.932629+480 E15217547A392    LEVEL: Warning (OS)
PID    : 307360             TID  : 8225       PROC : java
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED  : OS, -, unspecified_system_function
OSERR : ENOENT (2) "路径名中的文件或目录不存在。"
DATA #1 : File name, 24 bytes
/BigData/ufsoft/db2inst1[/PHP]

使用道具举报

bpmfhu

版主

风往北吹

精华贴数: 14
技术积分: 9700
社区积分: 1569
注册时间: 2001-12-26

论坛徽章:: 53

发表于 2007-5-28 14:24:24 |显示全部楼层

什么情况下出的错误?
你是不是调用什么东西结果os找不到？
检查一下路径参数之类的？

使用道具举报

diablo2

版主

星期一到星期五，天天都挺忙

精华贴数: 6
技术积分: 33049
社区积分: 9129
注册时间: 2002-1-23

论坛徽章:: 214

2010广州亚运会纪念徽章:跆拳道
日期:2010-10-20 20:14:36

发表于 2007-5-28 15:55:49 |显示全部楼层

OS? db2level?

使用道具举报

wangzhonnew

版主

Murphy was an optimist

精华贴数: 29
技术积分: 11728
社区积分: 579
注册时间: 2005-11-12

论坛徽章:: 32

2010广州亚运会纪念徽章:羽毛球
日期:2010-09-15 09:35:52

发表于 2007-5-28 18:55:44 |显示全部楼层

These functions sqloxltc_app() and sqleAttachCtx() are trying to
attach to a context & the first function basically is there to acquire a
latch, but this fails with an EINVAL (Invalid argument).
There are 2 possible solutions provided to customers who have reported
this in the past :-
- Insufficient semaphore resource. Use TCP/IP loopback connection as
workaround.
- Test by enabling DB2NOEXITLIST
http://publib.boulder.ibm.com/in ... /admin/r0005669.htm
"db2set DB2NOEXITLIST=ON" and restart instance

使用道具举报

anlinew

版主

按妞

精华贴数: 6
技术积分: 12275
社区积分: 436
注册时间: 2002-11-4

论坛徽章:: 43

发表于 2007-5-29 09:45:54 |显示全部楼层

最初由 diablo2 发布
[B]OS? db2level? [/B]

db2diag.log里的

使用道具举报

anlinew

版主

按妞

精华贴数: 6
技术积分: 12275
社区积分: 436
注册时间: 2002-11-4

论坛徽章:: 43

发表于 2007-5-29 09:46:59 |显示全部楼层

谢谢各位回复，下次再出问题，我让他们好好描述一下
这次先不管了

使用道具举报

rabbit.w.h

注册会员

中级会员

精华贴数: 0
技术积分: 686
社区积分: 138
注册时间: 2002-5-28

论坛徽章:: 1

发表于 2007-5-29 16:05:17 |显示全部楼层

如果文件系统没有问题的话，重新启动数据库，记住db2stop 后必须杀掉所有db2进程后再启动，注意操作之前备份，有一点风险

使用道具举报

whiterain

注册会员

高级会员

精华贴数: 2
技术积分: 3507
社区积分: 23
注册时间: 2004-7-15

论坛徽章:: 8

2010广州亚运会纪念徽章:高尔夫球
日期:2010-11-22 15:29:49

发表于 2007-5-29 21:17:56 |显示全部楼层

quote:
--------------------------------------------------------------------------------
最初由 diablo2 发布
OS? db2level?
--------------------------------------------------------------------------------

db2diag.log里的？？
有什么啊有，你发的就是一个片段！全的diag当然有了

使用道具举报

		自动登录	找回密码
密码			注册

帮忙看看，什么问题 [复制链接]

浏览过的版块