生活生产服务其它

TSM v5 SQL数据库错误求助

名不副实,嘿嘿,从国外网站转过来的问题:The following script worked at TSM v5.5.3.0: Q_OFFLINE 1 select cast(drives.library_name as char(6)) as "LIB", - 5 cast(drives.drive_name as char(10)) as "DRIVE", - 10 cast(source_name as char(15)) as "PATH", - 15 ca...显示全部
名不副实,嘿嘿,从国外网站转过来的问题:
The following script worked at TSM v5.5.3.0:

Q_OFFLINE 1 select cast(drives.library_name as char(6)) as "LIB",
-
5 cast(drives.drive_name as char(10)) as "DRIVE", -

10 cast(source_name as char(15)) as "PATH", -

15 cast(drives.online as char(5)) as "DRIVE ONLINE?", -

20 cast(paths.online as char(5)) as "PATH ONLINE?" -

25 from drives,paths where -

30 drives.library_name=paths.library_name and -

35 drives.drive_name=paths.destination_name -

40 and (paths.online='NO' or drives.online='NO')


At TSM v5.5.5.0 it produces the following error:

tsm: LIBMGR>run q_offline
ANR2914E SQL identifier token 'DRIVES.LIBRARY_NAME' is too long; name
or
component exceeds 18 characters.

|

............V..................................................
select cast(drives.library_name as char(6)) as "LIB",
cast(driv

ANR1463E RUN: Command script Q_OFFLINE completed in error.
ANS8001I Return code 3.

Any idea on how to fix this?收起
参与1

返回davym的回答

davymdavym其他3D动力
There is an efix available for this. You need to get a PMR opened and
escalated. They told me 5.5.5.1 isn't due until mid/late Q1
并给了IBM官方对这个问题的解决办法:http://www-01.ibm.com/support/docview.wss?uid=swg1PM24818

原文地址:http://www.backupcentral.com/php ... v5-sql-help-109096/,有兴趣的朋友可以去订阅这个论坛 的mailist
生活生产服务其它 · 2010-11-23
浏览1091

回答者

davym
其他3D动力
擅长领域: 安全数据安全存储

davym 最近回答过的问题

回答状态

  • 发布时间:2010-11-23
  • 关注会员:0 人
  • 回答浏览:1091
  • X社区推广