Maximum capacities in AS400

Maximum capacities in AS400
Maximum capacities in AS400, ibmi system limitation, as400 maximum limits, SQL limits, file systsem imits, ifs limits, db2 for i limits,
Maximum capacities in AS400

There are some system's maximum capacities and system limitations that we must know in advance before experiencing any surprise.

Limits Maximum value
Maximum number of spool files per job 999999
Maximum number of jobs in a subsystem 2147483647
Maximum number of active subsystem 32767
Maximum number of jobs on the system 970000
The maximum length of a password 128
Maximum number of objects saved using save or
restore command
300
The maximum number of journal receiver associated
with one journal
131036
Maximum number of objects associated
with one journal
10000000
Maximum number of libraries in the system
part of the library list
15
Maximum number of libraries in user
part of the library list
250
Maximum size of a stream file approx. 1 terabyte
Schema Name limit 128 chars
Minimum SMALLINT value -32768
Maximum SMALLINT value +32767
Minimum INTEGER value -2147483648
Maximum INTEGER value +2147483647
Minimum BIGINT value -9223372036854775808
Maximum BIGINT value +9223372036854775807
Maximum DECIMAL position 63
The maximum length of the JSON document 2147483647 bytes
Minimum DATE value 0001-01-01
Maximum DATE value 9999-12-31
Minimum TIME value 00:00:00
Maximum TIME value 24:00:00
Minimum TIMESTAMP value 0001-01-01-00.00.00.000000000000
Maximum TIMESTAMP value 9999-12-31-24.00.00.000000000000
Maximum number of columns in a table 8000
Maximum number of constraints on the table 5000
Maximum number of columns in a UNIQUE constraint 120
Maximum number of triggers on the table 300
Number of key fields in a file 120 fields
Number of physical file members in logical file member 32 members
Size of zoned decimal or packed decimal field 63 digits
Maximum number of members in the physical or logical file 32767

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain