扩表空大小，需要考虑系统文件大小的限制吗？
扩表空大小，需要考虑系统文件大小的限制吗？
今天刚被同事问到客户需要把Page是4k的表空间扩多61g，这个表空间还是单容器的..
理论上是可以的，但需要考虑但容器文件系统的大小也是受操作系统的限制
需要如下查看：
ulimit -a 看创建文件系统的限制
查看fsize的限制
grep -ip default /etc/security/limits
grep -ip instance /etc/security/limits
instance 是实例名，如果实例下没有fsize则是使用默认default的fsize
$sudo grep -ip default /etc/security/limits
*
* Sizes are in multiples of 512 byte blocks, CPU time is in seconds
*
* fsize - soft file size in blocks
* core - soft core file size in blocks
* cpu - soft per process CPU time limit in seconds
* data - soft data segment size in blocks
* stack - soft stack segment size in blocks
* rss - soft real memory usage in blocks
* nofiles - soft file descriptor limit
* fsize_hard - hard file size in blocks
* core_hard - hard core file size in blocks
* cpu_hard - hard per process CPU time limit in seconds
* data_hard - hard data segment size in blocks
* stack_hard - hard stack segment size in blocks
* rss_hard - hard real memory usage in blocks
* nofiles_hard - hard file descriptor limit
*
* The following table contains the default hard values if the
* hard values are not explicitly defined:
*
* Attribute Value
* ========== ============
* fsize_hard set to fsize
* cpu_hard set to cpu
* core_hard -1
* data_hard -1
* stack_hard 8388608
* rss_hard -1
* nofiles_hard -1
*
* NOTE: A value of -1 implies "unlimited"
*
default:
fsize_hard = -1
core_hard = -1
cpu_hard = -1
data_hard = -1
rss_hard = -1
stack_hard = -1
nofiles_hard = -1
fsize = -1
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000
$
除了安全方面的限制，单个文件大小还受文件系统类型的限制，AIX下主要使用JFS和JFS2文件系统。JFS最大只能支持64G的单个文件，有时候做大文件的归档备份时，有可能会超过这个限制的，所以建议使用JFS2文件系统。
| Functions | JFS2 | JFS |
|---|---|---|
| Fragments/Block Size | 512-4096 Block sizes | 512-4096 Frags |
| Maximum file system size | 16 Terabytes | 1 Terabyte |
| Maximum file size | 16 Terabytes | 64 GB |
| Number of i-nodes | Dynamic, limited by disk space | Fixed, set at file-system creation |
| Directory organization | B-tree | Linear |
| Compression | No | Yes |
| Quotas | No | Yes |
| Error logging | Yes | Yes |
怎么查看我的文件系统是什么类型的文件类型呢？
$/usr/sysv/bin/df -n
/ : jfs2
/usr : jfs2
/var : jfs2
/tmp : jfs2
/home : jfs2
/admin : jfs2
/proc : procfs
/opt : jfs2
/var/adm/ras/livedump: jfs2
怎么查看系统的blocksize呢？
$getconf PAGESIZE
4096
$
关于DB2层面中，如4k的超过限制空间，变大对应的表空间，会报如下错误