IBM GC23-7753-05 Default Sbspace Name, Location, Size, and Page Size, Configuring IDS Manually

Page 48

Default Sbspace Name, Location, Size, and Page Size

An sbspace is a logical storage area that the database server uses to store smart large objects (CLOB and BLOB data).

The default sbspace is the location in which the database server stores a smart large object if you do not specify an sbspace name when you create the smart large object. The database server also uses the default sbspace to store user-defined statistics.

Specify the primary and mirror data-storage location for the default sbspace:

vPrimary Data Location. By default, the Primary Data Location of the sbspace is the current drive and must have a minimum of 200 megabytes. The installation program displays the amount of available disk space. This location also specifies the value of the SBSPACENAME configuration parameter.

vMirror Location. The mirrored location serves as the backup area if the primary storage device fails. The mirrored location should be the same size as the primary location and should be in a different drive.

vSize. The size of the sbspace should be at least 200 megabytes.

vPage Size. The size of the sbpage should approximate the size of the most frequently occurring smart large object that the sbspace holds. The default is one page.

For more information about sbspaces, see the IBM Informix Dynamic Server Administrator’s Guide.

Shared Server Definition Computer

The shared server definition computer is the machine hosting the database server instance with which client computers connect if you are deploying Dynamic Server in a networked Windows environment.

Specify where you want the sqlhosts registry information for the shared server definition to be stored. You can choose either the local host machine or another computer that hosts a central, shared repository of sqlhosts settings for multiple database servers in the network.

If you specify another computer on the network, you must set the INFORMIXSQLHOSTS environment variable on your local computer to the name of the computer that stores the sqlhosts information.

Configuring IDS Manually

Use the Server Instance Manager if you want to configure the database server manually after installation of the product.

To configure the installed database server:

1.Open the Server Instance Manager utility and specify the following: v database server number

vdatabase server name

vservice name and port number for the TCP/IP network protocol

2.If you selected custom installation setup:

a.Specify a name for the root dbspace.

b.Specify the primary and mirror storage location and disk-space size for the root dbspace.

3-6IBM Informix Dynamic Server Installation Guide for Windows

Image 48
Contents IBM Informix Dynamic Server Installation Guide for Windows Page IBM Informix Dynamic Server Installation Guide for Windows Copyright International Business Machines Corporation 1996 Contents Index Introduction IBM Informix Dynamic Server EditionsAbout This Publication Types of Users Overview ReferenceWhat’s New in Version 11.50.xC4 Documentation Conventions Feature, Product, and Platform Markup Technical ChangesExample Code Conventions Html documentationSyntax Diagrams Additional DocumentationCompliance with Industry Standards Component represented in Html MeaningHow to Read a Command-Line Syntax Diagram Distinct UniqueSetting the Run Mode Keywords and PunctuationHow to Provide Documentation Feedback Identifiers and NamesPage Preparing to Install IDS on Windows Verifying Administrators Group MembershipOnline Notes Verifying System Requirements Multiple Copies of IDS on One Computer Multiple copies of different versionsMultiple copies of the same version Programs menuChoosing Your Installation Setup Installation Application Setup TypesRelated tasks Installable Features of IDS FeaturesBase Server Backup and Restore Conversion and Reversion SupportXML Publishing Global Language SupportIDS Configuration File Demonstration Database ServerDemonstration Database Server on Your System Instance Configuration Wizard Planning Role SeparationInstallation Directory Choosing between Local and Domain InstallationsIxdbsso IxaaoLocal Installation Domain Installation with Domain Administrator PrivilegesUser informix Upgrading the Database ServerInstalling IDS on Windows Installing IBM Informix ProductsInstalling a Copy of IDS on a Computer Installing with the GUI Typical Setup Related conceptsRelated reference Installing with the GUI Custom Setup GUI feature tree Performing a Silent Installation Using a Customized server.ini File for Silent Installation Using a Response File for Silent InstallationTo perform a silent installation by using a response file Silent Installation on a Host with Multiple Installations %WINDIR%\setup.issSilent Installation Response Codes Code DescriptionSetting Up Cluster Installations Cluster InstallationsOverview of Implementing a Cluster on Two Nodes Setting Up a Cluster Installation Preparing to Set Up a ClusterTo set up a cluster on the primary node Installing IDS as a Cluster on the Secondary Node Implementing a Cluster on the Primary NodeIDS as a Cluster on the Secondary Node Upgrade of IDS by Overwriting an Existing Installation Overwriting an Existing IDS InstallationMultiple Residency Planning for Multiple ResidencyCreating a New Database Server Instance Server Instance Manager Command-Line Options PurposeTroubleshooting Installation Problems Option System Meaning16IBM Informix Dynamic Server Installation Guide for Windows Post-Installation Tasks on Windows Working with the InstallationInstallation Automatic Actions IDS Program Group Initializing and Starting the Database Server Server-nameDatabase Server Configuration After Installation Choose Start Control Panel Administrative ToolsStopping the Database Server Database Server NumberService Name and Port Number Database Server NameDbspace Name, Location, and Size Default Sbspace Name, Location, Size, and Page Size Configuring IDS ManuallyTo configure the installed database server Shared Server Definition ComputerPost-Installation Tasks Windows 8IBM Informix Dynamic Server Installation Guide for Windows Altering IDS Features Modifying IDS on WindowsAltering Copies of IDS Uninstalling IDS Reinstalling the Database ServerPerforming Silent Uninstallations of IDS InstnumCommand 4IBM Informix Dynamic Server Installation Guide for Windows Deploying IDS with the Deployment Utility Deployment Utility+ Rapid IDS Embeddability with the Deployment Utility Initialized dbspacesDatabase Server Configuration Environment VariablesCreating a Snapshot for Deployment Deploying a Snapshot with the Deployment UtilityDatabase Server Aliases Ifxdeploy Command The Deployment Utility SyntaxIfxdeploy.conf file Command Options Informix-Admin groupElement Purpose Key Considerations DelifxForce Usage Examples of Deployment Utility Usage on Windows Example of Value Setting ParametersIfxdeploy.conf file is in $INFORMIXDIR/etc/ on Linux INFORMIXDIR%\etc on WindowsNo Onconfig Onconfig.stdInformix Ifxdeploy.conf file forServername\rootdbsdat.000 Following shows the contents of the ifxdeploy.conf file + ifxdeploy.conf File Template#SYSTEM Informix and the administrative group + Removing a Snapshot with the Deployment Utility16IBM Informix Dynamic Server Installation Guide for Windows Appendix. Accessibility 2IBM Informix Dynamic Server Installation Guide for Windows Host Host 4IBM Informix Dynamic Server Installation Guide for Windows Copyright IBM Corp Copyright License Trademarks 4IBM Informix Dynamic Server Installation Guide for Windows Index Special characters Dbservername Mirrorpath Sbspacename ServernumINFORMIXDIR% Dbservername TCP/IP Page GC23-7753-05