The dbgen and dbgenm GPL applications are random data generators that use the Bbuuzzb database engine or server.

The dbgen application is designed for stand-alone use. The Bbuuzzb database engine is linked into this binary/executable. Before you can run the dbgen application, you must set up a database engine configuration file called dbeng.cfg with a minimum of the tmp_path and log entries (the catalog entry is optional but recommended in single user mode).

The dbgenm application is designed for client/server environments and use either TCP sockets or QNX message passing IPC method. Any mention of QNX in this document refers to the QNX 4.x OS.

dbgenm requires a Bbuuzzb database server running. The dbgenm application communicates with the Bbuuzzb database server, the socloc server and the system log server through TCP sockets. In order to get dbgenm to successfully connect to the Bbuuzzb database server, the server must already be running and registered with the socloc server and there must be at least one socloc server and at least one system log server running within the environment. A socloc startup file must also be composed to connect to a socloc server. The database configuration file is not required for the dbgenm application.

Only the TCP IPC version of dbgenm requires a socloc server and a socloc startup file. The requirement for a system log server however, is part of all versions of dbgen.

All configuration files must be located in the same directory as the binary/executable program. The dbgen and dbgenm applications must be executed within their current directory so the program can locate the configuration files.

The dbgen application can be compiled for all stated platforms. The dbgenm application can be compiled on all stated platforms except DOS where there is no IPC. Under the Linux/Unix/QNX operating systems, the dbgen application can be compiled using the mkdbgen script. The dbgenm application can be compiled using the mkdbgenm script.

Program Syntax

dbgen and dbgenm both have the same program syntax:

   dbgen[m] -v -u -rnn -fnn rec_num table_name

Where:

• v - generate variable length numbers (default=no, fixed at 3 digits)
• u - generate random number of sub-fields and sub-sub-fields
• r - maximum number generated (default=999, cannot exceed three digits)
• f - number of fields to generate in each record (default=random,max=25)
• rec_num - number of records to generate
• table_name - name of table

The table_name must be given in accordance with the new.table guidelines. This program will attempt to create a new table. It is an error if the table already exists.