我是刚刚接触db2的新手,我在恢复数据库的时候使用db2 "restore database BDCC60 from C:databakpzyydb taken at 20110907030003 logtarget C:databakpzyydblogs without prompting"这个命令,然后提示SQL0968C 文件系统已满。 SQLSTATE=5... 显示全部
我是刚刚接触db2的新手,我在恢复数据库的时候使用db2 "restore database BDCC60 from C:databakpzyydb taken at 20110907030003 logtarget C:databakpzyydblogs without prompting"这个命令,然后提示SQL0968C 文件系统已满。 SQLSTATE=57011,我在网上找了很久都没有找到解决的方法,请问这个问题该如何解决? 收起
One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container.
The statement cannot be processed.
User Response:
Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required.
On unix-based systems, this disk full condition may be due to exceeding the maximum file size allowed for the current userid. Use the chuser command to update fsize. A reboot may be necessary.
This disk full condition may be caused when containers are of varying sizes. If there is sufficient space in the file system, drop the table space and recreate it with containers of equal size.