Creating SMA applications

To create an application that uses SMA, you must prepare your system for SMA use, configure solidDB^®, set your application to use the SMA driver, start the SMA server, and connect your application to it.

This procedure provides an overview on how to create SMA applications. The SMA applications for C/ODBC environments are created in a similar way to applications that are not using SMA.

Note When developing your application, it is recommended to use a network-based connection. Once your application is ready, switch to using the SMA connection.

For an example of a SMA application written in C, see the SMA sample in the samples/sma directory in your solidDB^® installation directory.

1 Check the system settings for shared memory use in your environment.

The default values for shared memory use in your environment may not be sufficient for using SMA. For details on viewing and setting the shared memory system parameters on your system, see Modifying shared memory kernel parameters: Overview.

2 Set up your database environment by creating a working directory, your solidDB^® database, and user accounts.

For instructions, see Creating a new database in the solidDB^® Administrator Guide.

Note The application and the SMA server processes must have identical file access permissions (database files, log files, and so on). The file access permissions are not checked at startup; subsequently, insufficient file access permissions may cause the SMA server to crash at a later point.

3 Configure solidDB^® to meet your environment, performance, and operation needs.

Use the solid.ini configuration file to define basic configuration settings such as database file names and locations, database block size, and so on.

▪In normal setups, it is not necessary to modify the SMA-specific parameters in the [SharedMemoryAccess] section of the solid.ini file. The factory values are applicable to most use cases.

▪Do not set the Srv.ProcessMemoryLimit parameter when using SMA. If you need to limit the memory the SMA server uses, use the SharedMemoryAccess.MaxSharedMemorySize parameter.

If there is no configuration file, the factory values are used.

You can set up your application to use SMA with or without a driver manager.