Some questions about Dynamic Server - HELP

Hi, I am preparing a comparision of different RDBMs for my boss. I am curious about some questions (I can't find answers on Informix site). What phisical limitations for database elements does Dynamic Server have? I.e.: maximum count of tables = max size of one table = max size of one record = max count of fields in one record = max count of records in table = max count of indexes = max count of indexes per table = Does Dynamic Server support distributed queries and transactions, similar to Oracle or Sybase? Does Dynamic Server and related tools include any CASE tool? What do you think about Informix Dynamic 4GL, is it good tool? Under which operating systems does it work? How good (or bad) is technical support from Informix, what is the quality of technical documantation? Can you help me? Thanks in advance Leszek Kozlowski.

Most of these types of questions can be found in the release notes. I would suggest that you read them. They are found in $INFORMIXDIR/release/<language_type (i.e. in the United States en_us)>/<Specific language (i.e. on NT 04e4)>/SERVERS_<level>. For instance on my NT laptop, it can be found in %INFORMIXDIR%\\release\\en_us\\04e4\\SERVERS_920.txt. On my Solaris machine it is found in $INFORMIXDIR/release/en_us/0333/SERVERS_920.txt. Look for "Limits in". Thats where the information begins. I'm copying the information from my NT installation below. It might help. Limits in Informix Dynamic Server ================================= Maximum Capacity System-Level Parameters per Computer System ----------------------------------------------------------------- Dynamic Server systems per computer...........................255 (Dependent on available system resources) Maximum number of accessible remote sites........machine specific Maximum Capacity Table-Level Parameters (based on 2K page size) per Table ----------------------------------------------------------------- Data rows per fragment............................. 4,277,659,295 Data pages per fragment............................... 16,775,134 Data bytes per fragment........................... 33,818,671,136 (excludes Smart Large Objects (BLOB, CLOB) and Simple Large Objects (BYTE, TEXT) created in Blobspaces) Binary Large Object bytes.................................. 2**31 Row length................................................ 32,767 Number of columns............................................ 32K Columns per index............................................. 16 Bytes per index...............................................390 Maximum Capacity Access Capabilities per Dynamic Server System ----------------------------------------------------------------- Maximum databases per Dynamic Server system........... 21 million Maximum tables per Dynamic Server system............. 477,102,080 Maximum active users per Dynamic Server system.. 32K user threads (minus the minimum number of system threads) Maximum active users per database and table..... 32K user threads (also limited by the number of available locks, a tunable parameter) Maximum number of open tables per Dynamic Server system... 32,000 Maximum number of open tables per user and join........... 32,000 Maximum locks per Dynamic Server system and database... 8 million 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.................................. 20 (applies only to simple large objects: TEXT and BYTE data types) Maximum number of B-tree levels............................... 20 Maximum amount of decision support memory....... machine specific Dynamic Server System Defaults ----------------------------------------------------------------- Table lock mode............................................. Page Initial extent size...................................... 8 Pages Next extent size......................................... 8 Pages Read-only isolation level......................... Committed Read (with database transactions) Read-only isolation level........................ Repeatable Read (MODE ANSI database) 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 Leszek Kozlowski wrote: > Hi, > > I am preparing a comparision of different RDBMs for my boss. I am > curious about some questions (I can't find answers on Informix site). > > What phisical limitations for database elements does Dynamic Server > have? I.e.: > maximum count of tables = > max size of one table = > max size of one record = > max count of fields in one record = > max count of records in table = > max count of indexes = > max count of indexes per table = > > Does Dynamic Server support distributed queries and transactions, > similar to Oracle or Sybase? > > Does Dynamic Server and related tools include any CASE tool? > > What do you think about Informix Dynamic 4GL, is it good tool? Under > which operating systems does it work? > > How good (or bad) is technical support from Informix, what is the > quality of technical documantation? > > Can you help me? > > Thanks in advance > > Leszek Kozlowski. -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================

Leszek, Madison already answered some of your questions. Here are the others. Informix supports distributed transactions and replication. Informix 4GL is great, is supported on most platforms (Linux, AIX, SUN, NT), and is widely used and depended upon. Technical support is adequate. Documentation is thorough. Classroom training is excellent. Wal-Mart, Kmart, Sears, and many, many others use Informix for their operational, managerial, and accounting needs. What better endorsement can you get. Good luck, Marc Thompson Data Definitions, Inc. Lincoln, NE Leszek Kozlowski <leszek-kozlowski@set.com.pl> wrote in message news:3879C91C.EC27F555@set.com.pl... > Hi, > > I am preparing a comparision of different RDBMs for my boss. I am > curious about some questions (I can't find answers on Informix site). > > What phisical limitations for database elements does Dynamic Server > have? I.e.: > maximum count of tables = > max size of one table = > max size of one record = > max count of fields in one record = > max count of records in table = > max count of indexes = > max count of indexes per table = > > Does Dynamic Server support distributed queries and transactions, > similar to Oracle or Sybase? > > Does Dynamic Server and related tools include any CASE tool? > > What do you think about Informix Dynamic 4GL, is it good tool? Under > which operating systems does it work? > > How good (or bad) is technical support from Informix, what is the > quality of technical documantation? > > > Can you help me? > > > Thanks in advance > > Leszek Kozlowski. > >

Madison Pruet wrote in message <3879DED4.4EF644F4@informix.com>... >Most of these types of questions can be found in the release notes. I >would suggest that you read them. They are found in... I inferred from his question that he was doing an evaluation prior to purchase. In that case he wouldn't have the release notes. Refarding documentation, I think it is generally very good. In my opinion some topics. for example SQL, are distributed across too many manuals, and there is lacking an overview document that describes the full product set. I still receive stuff and think "What the hell is this?" Technical Support in the UK is generally OK, but a lot of stuff is referred back to the US. Based upon opinions on this site, US customers seem to have a better opinion of Tech Support.

You can find all you need from the Informix DB Admin manuals which can be downloaded from the Informix website, and the web site is open for all. Leszek Kozlowski <leszek-kozlowski@set.com.pl> wrote in message news:3879C91C.EC27F555@set.com.pl... > Hi, > > I am preparing a comparision of different RDBMs for my boss. I am > curious about some questions (I can't find answers on Informix site). > > What phisical limitations for database elements does Dynamic Server > have? I.e.: > maximum count of tables = > max size of one table = > max size of one record = > max count of fields in one record = > max count of records in table = > max count of indexes = > max count of indexes per table = > > Does Dynamic Server support distributed queries and transactions, > similar to Oracle or Sybase? > > Does Dynamic Server and related tools include any CASE tool? > > What do you think about Informix Dynamic 4GL, is it good tool? Under > which operating systems does it work? > > How good (or bad) is technical support from Informix, what is the > quality of technical documantation? > > > Can you help me? > > > Thanks in advance > > Leszek Kozlowski. > >