Re: upgrade from IBM IDS version 7 to version 9

["Igor Zaiets" <zaiets@ukr.net>]

Внимательно смотрите релизы!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Это для 9.30


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

IX. Limits in IBM Informix Dynamic Server
The following table lists selected capacity limits and system defaults for
this release of IBM Informix Dynamic Server.


      System-Level Parameters
        Maximum Capacity
      per Computer System

      IBM Informix Dynamic Server systems per computer
      (Dependent on available system resources)
                                     255

      Maximum number of accessible remote sites
               Machine specific


      Table-Level Parameters (based on 2K page size)
         Maximum Capacity
                per Table

      Data rows per fragment.
                    4,277,659,295

       Data pages per fragment.
                        16,775,134

      Data bytes per fragment
      (excludes Smart Large Objects (BLOB, CLOB) and Simple Large Objects
(BYTE, TEXT) created in Blobspaces)
                  33,818,671,136

      Binary Large Object BLOB/CLOB pages.
                                 2**31

      Binary Large Objects TEXT/BYTE bytes
                                 2**31

      Row length
                               32,767

      Number of columns
                                   32K

      Columns per index
                                     16

       Bytes per index.
                                   390


      Access Capabilities
     Maximum Capacity
      per System

       Maximum databases per Dynamic Server system
                            21 million

       Maximum tables per Dynamic Server system
                       477,102,080

       Maximum active users per Dynamic Server (minus  the minimum number of
system threads)
                32K user threads


       Maximum active users per database and table (also limited  by the
number of available locks, a tunable parameter)
                32K user threads


       Maximum number of open tables per Dynamic  Server system
             Dynamic allocation

       Maximum number of open tables per user and join
             Dynamic allocation

       Maximum locks per Dynamic Server system and  database
             Dynamic allocation

       Maximum number of page cleaners
                                   128

       Maximum number of recursive synonym mappings
                                     16

       Maximum number of tables locked by user
                                     32

       Maximum number of cursors per user
                 Machine specific

       Maximum chunk size
                        2 gigabytes

       Maximum number of 2K pages per chunk
                             1 million

      Maximum number of open BLOBs
      (applies only to TEXT and BYTE data types)
                                     20

      Maximum number of B-tree levels
                                     20

      Maximum amount of decision support memory
                Machine specific


      IBM Informix Dynamic Server System Defaults


      Table lock mode
                                  Page

      Initial extent size
                              8 pages

      Next extent size
                              8 pages

      Read-only isolation level (with database transactions)
                Committed Read

      Read-only isolation level (ANSI-compliant database)
                Repeatable Read


      ON-Monitor Statistics


      Number of displayed user threads
                                  1000

       Number of displayed chunks
                                  1000

       Number of displayed dbspaces
                                  1000

       Number of displayed databases
                                  1000

       Number of displayed logical logs
                                  1000




"Вячеслав" <jazva@niipt.ntu-kpi.kiev.ua> wrote in message
Pine.BSF.4.21.0206141200440.86094-100000@niipt.ntu-kpi.kiev.ua">news:Pine.BSF.4.21.0206141200440.86094-100000@niipt.ntu-kpi.kiev.ua...
не подскажет ли кто нибудь максимальное допустимое значение для sessid на
информикс 9.21?
есть приложение которое постоянно вынуждено открывать и закрывать
соединение.
соответственно получаем при двух последовательн╕х простмотрах статистики
по пользователям

c9af7c8  Y--P--- 5187
c9af7c8  Y--P--- 5188

а работать ему долго :)
заранее благодарен
-------------------
Вячеслав