AIX 6.1 sybase 12.5.3 文件大小限制
aix 6.1 sybase 12.5.3安装是没有什么问题的
但是在build SYBASE设备的设备的时候就遇到了如下：
Creating tempdb devices.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
syb_tempdb devices created OK
Creating data devices1.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data1 devices created OK
Creating data devices2.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data2 devices created OK
Creating data devices3................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data3 devices created OK
Creating data devices4.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data4 devices created OK
Creating log devices....................Size:2G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_log devices created OK
我想问一下，怎么修改AIX的文件系统对设备的限制？
/etc/security/limits已经修改如下了
sybase:
fsize = -1
core = 2097151
cpu = -1
data = -1
rss = -1
stack = -1
nofiles = 65536
但是在build SYBASE设备的设备的时候就遇到了如下：
Creating tempdb devices.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
syb_tempdb devices created OK
Creating data devices1.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data1 devices created OK
Creating data devices2.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data2 devices created OK
Creating data devices3................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data3 devices created OK
Creating data devices4.................Size:5G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_data4 devices created OK
Creating log devices....................Size:2G
Msg 5123, Level 16, State 1:
Server 'SYBASE', Line 1:
DISK INIT encountered an error while attempting to open/create the physical
file. Please consult the SQL Server error log (in the SQL Server boot
directory) for more details.
xb_log devices created OK
我想问一下，怎么修改AIX的文件系统对设备的限制？
/etc/security/limits已经修改如下了
sybase:
fsize = -1
core = 2097151
cpu = -1
data = -1
rss = -1
stack = -1
nofiles = 65536