Urgent Question on AIX File Limits

[sirrom]

I have a huge problem where I cannot checkpoint db’s on my AIX box.
I run CA Ingres on AIX Version 4
Ingres says the ckp’s are valid my app says they are valid however the ckp’s are only 3 bits long which is wrong.
I belive the problem is being caused by a file limit within AIX, I think it’s defaulted to 2000.
How can I up this limit ?? I am a bit stuck as I have had no ckp’s for 10 days.
Help please.
Thanks in advance.

 

[Thief]

you can try to
#smitty jfs

"change/show filesystem characteristics"

where u can change the default parameters for a file. Thief................
(In a confrontation between a rock and stream, the stream always wins, not because of strength but persistence.)

 

[aixqueen]

Not sure what you asking...must be me today.....two places to check
/etc/security/limits for nofiles....
and smitty chgsys for the number of processes for user...If I understand you correctly? Not sure................Maybe someone else?

General Info on what is supported for AIX 4.1 and 4.3:

AIX Version 4.1/4.2
Open files per process = 2,000
Threads per process = 512
Max size of shared or mapped files per memory segment = 256MB
Total open files per system = 200,000
Maximum size of 2 GB for a shared file
volume group 255 per system
physical volume 32 per volume group
physical partition 1016 per physical volume Up to 256 MB each in size
Logical volume 256 per volume group
Logical partition 32,512 per logical volume
2 GB file size limit. (in 4.2 it did up the support for over 2 GB for most commands
No support for executeables over 256MB
Filesystem limit 64GB

AIX Version 4.3.2

Open files per process = 32,767
Threads per process = 32,767
Max size of shared or mapped files per memory segment = 2GB
Total open files per system = 1,000,000
Support for files up to 64 GB/Filesystems up to 128 GB (supported)
Maximum size for shared or mapped files 2GB
physical volume 128 per volume group
Logical volume 512 per volume group


Are you asking where to make the processes per user increased?
smitty chgsys

Or are you asking about the /etc/security/limits file?
-----------------------------------
Change / Show Characteristics of Operating System

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

[Entry Fields]
Maximum number of PROCESSES allowed per user [128] +#
Maximum number of pages in block I/O BUFFER CACHE [20] +#
Maximum Kbytes of real memory allowed for MBUFS [0] +#
Automatically REBOOT system after a crash false +
Continuously maintain DISK I/O history true +
HIGH water mark for pending write I/Os per file [0] +#
LOW water mark for pending write I/Os per file [0] +#
Amount of usable physical memory in Kbytes 65536
State of system keylock at boot time normal
Enable full CORE dump false +
Use pre-430 style CORE dump false +


-----------------------

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
* Attribute Value
* ========== ============
* fsize_hard set to fsize
* cpu_hard set to cpu
* core_hard -1
* data_hard -1
* stack_hard -1
* rss_hard -1
* nofiles_hard -1
*
* NOTE: A value of -1 implies "unlimited"
*

default:fsize = 2097151
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000

 

[bi]

Regarding the size of files: If you are going to have large files (larger than 2 GB) in a logical volume (at least at 4.3.3), you have to create a large file enabled logical volume. If you don't create a large file enabled logical volume, even if all the other parameters (for example, fsize) are enabled to be greater than 2 GB or unlimited, you won't be able to have anything larger than 2 GB in the logical volume.