DB2修改(mv)数据库文件名称后的现象
来源:互联网 发布:淘宝pr剪切教程 编辑:程序博客网 时间:2024/05/16 09:34
[db2inst1@db10g T0000004]$ db2 connect to test
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g T0000004]$ db2 list tablespaces
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 3
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 4
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 5
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 6
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
[db2inst1@db10g TEST]$ ls
T0000000 T0000001 T0000002 T0000003 T0000004 T0000006
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g T0000004]$ db2 list tablespaces
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 3
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 4
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 5
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 6
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
[db2inst1@db10g TEST]$ ls
T0000000 T0000001 T0000002 T0000003 T0000004 T0000006
[db2inst1@db10g TEST]$ cd T0000003
[db2inst1@db10g T0000003]$ mv C0000000.LRG C00000000.LRG <<--将表空间对应的文件mv(后面多加了一个0)
[db2inst1@db10g T0000003]$ db2 connect to test
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g T0000003]$ db2stop
10/20/2015 15:02:48 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[db2inst1@db10g T0000003]$ db2start
10/20/2015 15:02:52 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst1@db10g T0000003]$ ll
total 590404
-rw------- 1 db2inst1 db2iadm1 603979776 Oct 19 14:05 C00000000.LRG
[db2inst1@db10g T0000003]$ db2 connect to test <<--将数据库文件改名重启db服务后还可以正常连接
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g T0000003]$ db2 connect to test
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g T0000003]$ db2stop
10/20/2015 15:02:48 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[db2inst1@db10g T0000003]$ db2start
10/20/2015 15:02:52 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst1@db10g T0000003]$ ll
total 590404
-rw------- 1 db2inst1 db2iadm1 603979776 Oct 19 14:05 C00000000.LRG
[db2inst1@db10g T0000003]$ db2 connect to test <<--将数据库文件改名重启db服务后还可以正常连接
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = TEST
[db2inst1@db10g ~]$ db2 list tablespaces
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 3
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x4000
Detailed explanation:
Offline
Tablespace ID = 4
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 5
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 6
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 3
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x4000
Detailed explanation:
Offline
Tablespace ID = 4
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 5
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 6
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
------mv数据文件后,竟然可以正常db2 connect to test,只不过表空间状态显示OFFLINE
阅读全文
0 0
- DB2修改(mv)数据库文件名称后的现象
- DB2修改(mv)数据库文件名称后的现象
- 修改SQLServer2008数据库文件名称(数据文件和日志文件)
- DB2添加以前的数据库文件
- Linux: mv, rename单次及批次修改档案名称及后缀(批量修改文件名)
- 修改数据库文件的路径
- TOMCAT发布后的名称修改
- db2修改计算机名后需要做的配置修改
- myeclipse 修改工程名称 后
- VS(2005)下,修改程序运行时任务栏合并后显示的名称
- 如何修改linux下设备名称(即用户名后的@XX)
- copy项目后修改项目的部署名称
- db2修改主机名后配置文件修改
- ios app 修改名称后,收到的推送通知 显示的仍然是上一个名称 问题
- db2 10.1 数据库文件介绍
- MyEclipse 修改项目名称后,如何更改部署到tomcat的项目名称
- MyEclipse修改项目名称后,部署到tomcat问题 显示旧的项目名称
- eclipse中项目名称修改后部署到tomcat中应用名称仍然是旧的
- 【Android】RxJava的使用(三)转换——map、flatMap
- ubuntu16.04 +NVIDIA驱动+cuda8.0+cudnn+andaconda+tensorflow(GPU版)+Spyder+pycharm全套配置
- linux上安装软件
- ArrayList<Integer> arr=new ArrayList<Integer>
- 三角形面积之海伦公式
- DB2修改(mv)数据库文件名称后的现象
- c++模板类
- 【Android】RxJava的使用(四)线程控制 —— Scheduler
- HDU 4804 Campus Design(插头DP) (未理解)
- 如何提高学习效率
- 复习 队列安排 链表
- 信息系统项目管理师备考记录 2017下半年
- 系统调用
- ubuntu内核相关问题总结