Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 7: Informix Dynamic Server replication

Ronald C. Privett (rprivett@us.ibm.com), Advanced Support Engineer, IBM
Ron Privett photo
Ron Privett is a member of the Advanced Support team, working with the Down Systems and Diagnostic group for IBM Informix engine products. He has worked with IDS for 10+ years, specializing in Replication issues a majority of that time. He has created customer tutorials, developed training materials, trained other engineers how to support ER, and presented at various user groups and user conferences in the past.

Summary:  Configure and manage all forms of replication options available with IBM® Informix® Dynamic Server (IDS) 11. The seventh in a series of eight tutorials, use this tutorial to help prepare for the IDS 11 exam 918.

View more content in this series

Date:  26 Jul 2007
Level:  Introductory PDF:  A4 and Letter (349 KB | 87 pages)Get Adobe® Reader®

Activity:  22744 views
Comments:  

SDS: Configuration

This section discusses the following topics:



Requirements

Except for disk requirements (which are shared with the primary server), hardware and software requirements are the same as for HDR secondary servers.

SDS nodes are not able to share temp spaces along with the primary. As a result, you have to specify temp space for each SDS node (there can be multiple DBSpace/chunks defined). The temp spaces are created when the SDS secondary is started. The dynamically created DBSpace/chunks are local to the SDS node. The DBSpace/chunks use the highest number to prevent any conflicts with chunk additions on the primary server. The primary and other SDS nodes are unaware of the local temp DBSpace.

Please review the next section on Onconfig parameters, and set each value before starting and SDS node.


New onconfig parameters


Table 18. New onconfig parameters for SDS
ParameterDescription
SDS_ENABLESet to 1 to enable SDS; 0 to disable
SDS_TIMEOUTSpecify an integer value for the amount of seconds a primary will wait for acknowledged log positions from the secondary nodes until it attempts to remove an SDS node
SDS_TEMPDBSUses the following pattern <name>,<path>,<pagesize>, <offset>,<size>. Since the SDS nodes are not able to share temp spaces, you have to specify for each secondary SDS node its own temp dbspace. The space will be created when the SDS secondary is started.
SDS_PAGINGSpecify two files where the SDS node will maintain its flushed pages

Starting SDS for the first time

Compaired to starting HDR, ER, or RSS, the process of starting an Shared Disk Secondary is simple.


Table 19. Starting an SDS node for the 1st time
StepOn the primaryOn the SDS node
1Set up shared disk environment
2Set SDS_ENABLE to 1 on primary
3Run onmode -d set SDS primary <alias>
4Configure SDS_ENABLE, SDS_PAGING, and SDS_TEMPDBS
5On SDS node, map the following to match the primary: ROOTNAME, ROOTPATH, ROOTOFFSET, ROOTSIZE, PHYSDBS, PHYSFILE, LOGFILES, LOGSIZE. It is advisable to map the other configuration parameters to match those of the primary server with the exception of DBSERVERALIASES, DBSERVERNAME, and SERVERNUM.
6Start the SDS node with the command oninit

23 of 28 | Previous | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=244712
TutorialTitle=System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 7: Informix Dynamic Server replication
publish-date=07262007
author1-email=rprivett@us.ibm.com
author1-email-cc=