AcuXDBC simplified setup using demo.bat



The setup for AcuXDBC seems very complex.  Where do I start?


The AcuXDBC installation's bin directory includes a batch file, demo.bat ( script file on UNIX), which automatically sets up AcuXDBC with sample data as a quick way to demonstrate its functionality. Modify it as follows so it can used to set up a custom AcuXDBC system catalog.

These instructions refer to the Windows version (demo.bat) but the same applies to on UNIX.  

First make a copy of demo.bat, and rename it, myxdbc.bat for this example.

Modify myxdbc.bat as follows:

1. Find this entry:

set XDBCAT="%GENESIS_HOME%\syscat"

Modify this entry to place the system catalog in a different location, or give it a different name.  For example:

set XDBCAT="C:\data\acuxdbc\mysyscat"

2. Immediately following that entry, add this entry:

set XFDDIR="C:\data\xfd"

Set it to indicate the directory where your extended file descriptors (XFDs) are located.

3. Find this entry:

call %XDBBIN�dfile -d %XDBCAT% -x %XDBDEMO%\xfd -f %XDBDEMO%\demo_list.txt

Change it to this:

call addfile -d %XDBCAT% -x %XFDDIR% -f %XFDDIR%\xfd_list.txt

where xfd_list.txt is the name of your list of XFDs.

Next create an XFD list for the files that will be included in the new system catalog.  The list must contain only the base name, not the xfd suffix. In this example the list name is  xfd_list.txt and it needs to be placed in the XFD directory.  It can be placed somewhere else and it can be named something else but make sure the "call" reflects that in step 3 above.  

To simplify that copy the xfd directory then execute  "rename *.xfd *." from a command prompt in that directory, to remove the .xfd extension.  Then execute "dir /B > xfd_list.txt" to create the list.

Check the environment variables. GENESIS_HOME should point to C:\Program Files\Acucorp\Acucbl800\AcuGT if you took the default installation.  PATH should include the 800\AcuGT\bin directory.  If there are other versions of Acucorp in the path then remove them or make sure that Version 8 is first.

Execute myxdbc.bat.  Ignore messages about "already in catalog" and "does not exist" as the script performs some steps that aren't necessary for a custom setup.  The new custom system catalog now exists but there is some configuration necessary so the driver can find the system catalog and the data.  

The AcuXDBC installation automatically created a configuration file, acuxdbc.cfg, in the GENESIS_HOME directory.  Edit that configuration file so that DICTSOURCE points to the custom system catalog (XDBCAT in step 1), and FILE_PREFIX specifies the custom data directories.  

While the file is open for editing, remove the pound sign (#) from the MAX_FILES line and set it to 64.  Look through the other parameters in the file to see if any might be applicable.  Most are commented out with # and indicate the default value.  If any non-default settings are needed, remove the # and enter the appropriate value.  (Note for AcuODBC users: these parameters correspond to the settings located in the DSN with AcuODBC.)  Save and close the acuxdbc.cfg.

The setup is now complete.  Set up a Data Source Name (DSN) as follows so any ODBC application may connect to the custom AcuXDBC system catalog:  

Start the Windows ODBC Data Source Administrator from Start, Programs, Acucorp 8.0.0, AcuXDBC, then set up as follows:

Click on the "System DSN" tab.

Click "Add".

Select "Acucorp AcuXDBC" and click "Finish".

Enter a name for the DSN.

Enter "system" in Username.

Enter "manager" in both password fields.

Click "OK" twice.

At this point all the steps necessary for creating a custom system catalog are done!

Old KB# 2854
Comment List