Starting srvconfig.sh

Start the command-line configuration utility by typing:

     srvconfig.sh

Sample srvconfig.sh session

The following sample srvconfig.sh session demonstrates the configuration of a new DSN and presents the majority of questions the utility asks. Your session may be slightly different depending on the particulars of your DSN or if you are modifying an existing DSN.

Note: The sample srvconfig.sh sessions indicate those areas where your response must be case-sensitive. If a comment about case-sensitivity does not appear, you can enter your response using either uppercase or lowercase letters.

Throughout the utility, defaults appear in square brackets at the end of each question. To accept the default, simply press Enter. In the sample session below, defaults have been chosen where you do not see a specific response to a question. Responses are shown in this type.

$ srvconfig.sh
AcuODBC Server configuration, Version 5.2
In which directory are your data source configuration (.dsn) files [.]?
This should match the value of DSN-DIRECTORY in your configuration file.

Press Enter to accept the default or enter the name of the directory. In this example, the default is the current directory. Section 8.3.3 provides information on the DSN_DIRECTORY configuration variable.

Current Data Sources:

If you have already configured data sources, they are listed here. If you are creating a new DSN, the name can be in either uppercase or lowercase letters. Future references to this DSN must be in the same letter case that you use in naming it here.

Data Source Name: testing Data Source Configuration file "testing" does not exist.

Do you wish to create it [Y]?

Enter Y to create a new DSN. Enter N if you do not wish to create a new DSN. If you enter N, you are requested again to enter a data source name.

General information

What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: g

XFD Directory: /usr/test/xfds

"XFD Directory" is a case-sensitive field. Enter the components of the path as they appear in the UNIX file system. Note that the names of XFD files that reside on the UNIX server, must be completely lowercase letters, such as "accounts.xfd."

Your current Data Directory values are:

(If you are modifying an existing DSN, data directories are listed here.)

Select a command:
Add, [Quit] a

If this is a new DSN, select Add, and enter the path and name of the directory that contains the source data files. Select Add as many times as necessary for the number of directories to be listed in this field. For performance reasons, these directories should be listed in the order in which you want AcuODBC to search them. Use "moveup" or "movedown" (described below) to change the search order.

Enter the new directory: /usr/test/data

You must enter values for the data directory. This is in contrast to the Windows versions where the data directory defaults to the same location as the XFD directory. Note that this is a case-sensitive field.

Your current Data Directory values are:
1)  /usr/test/data

Select a command
Add, Delete, [Quit]: a

"Delete" now appears as a choice. You can also add another directory.

Enter the new directory: /usr/test/book Your current Data Directory values are: 1) /usr/test/data 2) /usr/test/book

Select a command Add, Delete, Modify, MoveUp, MoveDown, [Quit]: moveup

You now have the option of changing the search order of these directories.

Enter the directory number to move up (between 1 and 2) [1]: 2

If you do not want to change the order of the directories, enter 1 or accept the default.

Your current Data Directory values are:
1)  /usr/test/book
2)  /usr/test/data

Select a command
Add, Delete, Modify, MoveUp, MoveDown, [Quit]: movedown

Enter the directory number to move down (between 1 and 2) [1]: 2
No directory moved

The default is the last assigned number, because that directory cannot be moved down.

Select a command
Add, Delete, Modify, MoveUp, MoveDown, [Quit]: q

Data File Extension [ ]

Advanced information

What type of information do you want to edit?
General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer
[Exit]: ad

File Case:
[Default], Upper, Lower:

Compiler Options
[DEF], DCI, DCM, DCN:

If you do not accept the default, you must enter one of the other choices in its entirety.

Character Set:
[ANSI], OEM:

Open Tables (between 0 and 100) [0]:

Character Types;
[Mixed], CHAR, VARCHAR:

Invalid Numeric Data:
[Error], Truncate, Zero:

Signed Index [N]?:

Read Only [Y]? N

Do you want to use a table name cache file [N]?

Null Processing
---------------

How should Vision alphabetic data of SPACES and LOW-VALUES be read?
[NULL], EmptyString:

How should Vision numeric data of SPACES and LOW-VALUES be read?
[NULL], ZERO:

How should NULL data alphabetic data be written to the Vision file?
SPACES, [LOW-VALUES]:

How should NULL numeric data be written to the Vision file?
SPACES, LOW-VALUES, [ZERO]:

The previous two questions appear only if you have defined your data source as read/write. They do not apply to read-only data sources.

Julian Base Date [01/01/1900] (MM/DD/YYYY):

Note that, at this release, srvconfig.sh does not verify the validity of a date. Be sure to check the date you enter in this field.

Vision information

What type of information to you want to edit?
General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer
[Exit]: v

Max files (between 32 and 256) [32]:

Max locks (between 32 and 8191) [32]:

Locks Per File (between 10 and 8191) [10]:

Buffers (between 0 and 256) [32]:
Transaction Support Options
---------------------------

Enable Transaction Processing Support [N]? Y

Enable logging [N]? Y

Encrypt Log File [N]?

Log to Device [N]?

Log File [ ]:  /usr/test/translog

"Log File" is a case-sensitive field.

Temp File Directory:  ../tmp

"Temp File Directory" is a case-sensitive field.

Log Buffer Size (between 0 and 32767) [512]:

Tracing information

What type of information do you want to edit?
General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer
[Exit]: t

Vision Tracing
--------------

Vision Trace Level (between 0 and 9) [0]:

Vision Trace File [%TEMP%/vision_trace_%d.log]:

If you are not using the default trace file, remember that your response to this prompt must be case sensitive.

Start Vision tracing [N]?
AcuODBC Driver Tracing
---------------------

Driver Trace Level (between 0 and 9) [0]:

Driver Trace File [%TEMP%/acuodbc_trace_%d.log]:

If you are not using the default trace file, remember that your response to this prompt must be case sensitive.

Start driver tracing [N]?
SQL Tracing
--------------

SQL Trace Level (between 0 and 9) [0]:

SQL Trace File [%TEMP%/sql_trace_%d.log]:

If you are not using the default trace file, remember that your response to this prompt must be case sensitive.

Start SQL tracing [N]?

File Alias information

What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: f

Your current File Aliases are:

Any already defined file aliases are listed here.

Select a command
Add, [Quit], a
Table Name:  cats
XFD:  pets
Data File:  /usr/test/data/file1

"Table Name", "XFD", and "Data File" are all case-sensitive fields.

Write Permission:
ReadOnly, Read/Write, [DSN Default]:

State:[Enabled], Disabled:

"State" is equivalent to the check box on the File Alias tab. See section 3.7, "File Aliases" for more information.

Your current File Aliases are: Table Name:XFD:Data File:Write Permission:State 1) cats:pets:/usr/test/data/file1:DSN Default:Enabled

Select a command Add, Modify, Delete, [Quit]; a

"Modify" and "Delete" now appear as choices.

Table Name: dogs XFD: pets Data File: /usr/test/data/file2 Write Permission: ReadOnly, Read/Write, [DSN Default]: State: [Enabled], Disabled: Your current File Aliases are: Table Name:XFD:Data File:Write Permission:State 1) cats:pets:/usr/test/data/file1:DSN Default:Enabled 2) dogs:pets:/usr/test/data/file1:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]: a Table Name: fish XFD: pets Data File: /usr/test/data/file3 Write Permission: ReadOnly, Read/Write, [DSN Default]: State: [Enabled], Disabled: Your current File Aliases are: Table Name:XFD:Data File:Write Permission:State 1) cats:pets:/usr/test/data/file1:DSN Default:Enabled 2) dogs:pets:/usr/test/data/file2:DSN Default:Enabled 3) fish:pets:/usr/test/data/file3:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]: m

Enter file alias number to modify (between 0 and 3) [0]:

Enter the number of the file alias you wish to edit. Enter 0 or accept the default if you do not want to make any changes.

Select a command
Add, Modify, Delete, [Quit]: q

The Multicompany "tab" is described in the next section, so this example proceeds directly to AcuServer.

AcuServer information

What type of information do you want to edit?
General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer
[Exit]: ac

AcuServer Password:
[None], Use, Ask: u
This method is not recommended because the password will be in the .dsn file
in plain text.
Are you sure you want to do this [N]?

AcuServer Password:
[None], Use, Ask: a

AcuServer Port (between 1 and 32767) [6523]:

International Character Map File: [ ]

"International Character Map File" is a case-sensitive field.

What type of information do you want to edit?
General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer
[Exit]:

Save the data [Y]? Y
$

If you do not save the data, all changes made during the session are lost.

Creating multicompany DSNs in a UNIX command-line environment

To create a multicompany DSN, you must configure both a master DSN and the individual DSNs that make up the master. See section 3.8, "Multicompany Support" for additional information.

Configuring the master DSN

$ srvconfig.sh In which directory are your data source configuration (.dsn) files [.]? This should match the value of DSN-DIRECTORY in your configuration file. Current Data Sources: testing.dsn Data Source Name: multi Data Source Configuration file "multi" does not exist. Do you wish to create it [Y]? What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: g XFD Directory [ ]: /usr/test/xfds Your current Data Directory values are:

Select a command Add, [Quit]: q

You will specify data directories when you provide Multicompany information.

Data File Extension [ ]

When specifying General information for a master DSN, specify only the XFD Directory.

.
.
.

Complete the other tabs as appropriate. The following steps demonstrate specifying Multicompany information, where you list the individual DSNs, the location of their data files, and their write permissions.

What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: m Is this a Master data source or a company-specific data source? [Master], Company-Specific: Your current Companies are:

Select a command Add, [Quit]: a Company: clinic01 Data Directory: /usr/clinics/clinic01

"Company" and "Data Directory" are both case-sensitive fields.

Write Permission
ReadOnly, Read/Write, [DSN Default]:

State
[Enabled], Disabled:

Enter Enabled if you want to include the company in the master DSN. Enter Disabled if you do not want to include the company. You can modify this later.

Company:Data Directory:Write Permission:State 1) clinic01:/usr/clinics/clinic01:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]: a Company: clinic02 Data Directory: /usr/hospitals/clinic02 Write Permission ReadOnly, Read/Write, [DSN Default]: State [Enabled], Disabled: Company:Data Directory:Write Permission:State 1) clinic01:/usr/clinics/clinic01:DSN Default:Enabled 2) clinic02:/usr/hospitals/clinic02:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]: a Company: clinic03 Data Directory: /usr/clinics/clinic03 Write Permission ReadOnly, Read/Write, [DSN Default]: State [Enabled], Disabled: Company:Data Directory:Write Permission:State 1) clinic01:/usr/clinics/clinic01:DSN Default:Enabled 2) clinic02:/usr/hospitals/clinic02:DSN Default:Enabled 3) clinic03:/usr/clinics/clinic03:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]: m Enter company number to modify (between 0 and 3) [0]: 2 Company [clinic02]: Data Directory:/usr/hospitals/clinic02]: /usr/clinics/clinic02 Write Permission ReadOnly, Read/Write, [DSN Default]: State [Enabled], Disabled: Your current Companies are: Company:Data Directory:Write Permission:State 1) clinic01:/usr/clinics/clinic01:DSN Default:Enabled 2) clinic02:/usr/clinics/clinic02:DSN Default:Enabled 3) clinic03:/usr/clinics/clinic03:DSN Default:Enabled Select a command Add, Modify, Delete, [Quit]:

What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]:

Supply any additional information as necessary and exit when you have finished configuring the DSN.

Save the data [Y]? Y
$

Creating company-specific DSNs in a UNIX command-line environment

When you create the individual, company-specific DSNs, you must provide only the name of the individual DSN and answer one question of Multicompany information. See "Creating Individual Company-specific DSNs" in Chapter 3 for additional information.

$ srvconfig.sh In which directory are your data source configuration (.dsn) files [.]? This should match the value of DSN-DIRECTORY in your configuration file. Current Data Sources: multi.dsn testing.dsn

Data Source Name: clinic01

The data source name you enter must match the Company name you provided as Multicompany information for the master DSN. This is a case-sensitive field.

Data Source Configuration file "clinic01" does not exist. Do you wish to create it [Y]? What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: m Is this a Master data source or a Company Specific data source? [Master], Company-Specific: c Enter the master data source name: multi What type of information do you want to edit? General, Advanced, Vision, Tracing, FileAlias, Multicompany, AcuServer [Exit]: exit

Save the data [Y]? Y $

Repeat this as necessary to provide the name of the individual data source and the name of the master data source for each individual company in the multicompany DSN. All other necessary information is contained in the master DSN.