KC Informix Users Group 10 Cheetah 2 Features.ppt

KC Informix Users Group 10 Cheetah 2 Features Presented By: Sanjit Chakraborty / Jeff Laube Date: Jan 22, 2009 Agenda Enhanced Configuration Options During Installation Automatic Statistics Updating Control External Directives for a Session Automatic Statistics Distributions with Create Index Enhanced Startup script customization Visual Explain BIGINT/BIGSERIAL Secure Socket Layer (SSL) Savepoints LIMITNUMSESSIONS KC Informix Users Group Feature 1: Enhanced Configuration Options During Installation Enhanced Configuration Options During Installation Instance Configuration Wizard Automatically creates and custom onconfig file for future use The onconfig file generates during create demonstration database server with custom setup GUI and Console installation wizard both supports Windows limitation – Only available with a custom setup in GUI mode Not available with silent installation Parameters value decides depending on hardware and database system needs Configuration file generated with Standard setting for any error encountered during using wizard Input for Configuration File Installation Directory Database Server Name Server Number Rootpath Rootsize No. of central processing units (CPUs) Memory: System RAM dedicated to the IDS server (in MB) No. of online transaction clients No. of decision support clients Updated Configuration Parameters ROOTPATH ROOTSIZE MSGPATH DBSERVERNAME DBSERVERALIASES SERVERNUM ALARMPROGRAM DRLOSTFOUND BAR_ACT_LOG BAR_DEBUG_LOG SYSALARMPROGRAM DUMPDIR JVPJAVAHOME JVPHOME JVPPROPFILE JVPLOGFILE JVPCLASSPATH BUFFERPOOL VPCLASS Files Generated Customized Onconfig file INFRMIXDIR/etc Onconfig file onconfig.server name Updated onconfig parameters will be added at bottom of the file Environment Setup Files INFRMIXDIR/demo/server profile_settings (ksh) Profile_settings.csh Enhanced Configuration Options During InstallationInstance Configuration Wizard  UNIX install (either Typi