DB2报错:SQL1043C Database Services could not initialize the system catalogs. Error "-968" was returned.

来源:互联网 发布:卖掉淘宝店铺的危险 编辑:程序博客网 时间:2024/05/22 10:39

我看了一些资料:原来是file system is full,解决方法:是增加文件系统

Question

The following error occurs when running wdbconfig.sh
db2 CREATE DATABASE tec USING CODESET UTF-8 TERRITORY US SQL1043C Database Services could not initialize the system catalogs. Error "-968" was returned.   AnswerTry creating more space for the home directory of the DB2 database and check the permissions on the home directory (rwxrwsr-x ) to see if the instance owner has read/write access to the directory.

Here is the explanation for the "-968" error (SQL0968)

SQL0968


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

 

 

 解决方法:在root用户下:更改fsize为100G,(209715100块512byte)
chuser fsize=209715100 db2admin
重启计算机
shutdown -Fr
再次登陆系统并切换用户为 db2admin

原创粉丝点击