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.shdb2 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
- DB2报错:SQL1043C Database Services could not initialize the system catalogs. Error "-968" was returned.
- services报错:Could not create the view: An unexpected exception was thrown.
- Db2 client上load from cursor报错SQL1013N The database name .. could not be found
- eclipse中services 报could not create the view;An unexpected exception was thrown
- Could not initialize proxy - the owning Session was closed
- Could not initialize proxy - the owning Session was closed
- could not initialize proxy - the owning Session was closed
- Hibernate: Could not initialize proxy - the owning Session was closed
- Could not initialize proxy - the owning Session was closed
- Could not initialize proxy - the owning Session was closed
- 异常:could not initialize proxy - the owning Session was closed
- 异常:could not initialize proxy - the owning Session was closed
- 异常:could not initialize proxy - the owning Session was closed
- could not initialize proxy - the owning Session was closed
- LazyInitializationException:could not initialize proxy - the owning Session was closed
- could not initialize proxy - the owning Session was closed
- 异常:could not initialize proxy - the owning Session was closed
- Could not initialize proxy - the owning Session was closed
- NSNotificationCenter用于增加回调函数
- 繁荣挖方外安放去
- PE学习1-导入表
- Androd Bluetooth Overview
- Strategy模式与Delegate委托
- DB2报错:SQL1043C Database Services could not initialize the system catalogs. Error "-968" was returned.
- 期待大家的关注和帮助
- 字符,字节和编码
- JQuery 学习文章转载
- Android Bluetooth Process Diagram
- PE学习2-导出表
- POJ 1258 Agri-Net (prim + kruskal)
- 匿名内部类
- 关于DataTable中DateTime跨时区的问题