医院 数据库
SQL0968C 文件系统已满。 SQLSTATE=57011
我是刚刚接触db2的新手，我在恢复数据库的时候使用db2 "restore database BDCC60 from C:databakpzyydb taken at 20110907030003 logtarget C:databakpzyydblogs without prompting"这个命令，然后提示SQL0968C 文件系统已满。 SQLSTATE=57011，我在网上找了很久都没有找到解决的方法，请问这个问题该如何解决？
3 同行回答
$ db2 ? SQL0968C
SQL0968C The file system is full.
Explanation:
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.
sqlcode : -968
sqlstate : 57011 收起
SQL0968C The file system is full.
Explanation:
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.
sqlcode : -968
sqlstate : 57011 收起