billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 
dbck
Prev  BillMax Executables  Next

Name

dbck — Database integrity check

Synopsis

/usr/local/billmax/bin/dbck [-h] [-v] [-t { table1,table2, ...} ] [-r] [-a] [-A] [-e] [-u] [-d days]

DESCRIPTION

Verify the integrity of a BillMax database. The following general areas are checked:

  • Referential integrity.

  • Various list references.

  • Many data aspects of the payhist table.

Data is NOT validated against any Constraints.

OPTIONS

-h

Show help for this program.

-v

Verbose. Output more comments about what is being done.

-t table1,table2,...

Specify a list of tables to check. Submit a comma delimited list.

-r

Repair database problems that are able to be automatically repaired and do not need manual intervention. By default, the user is prompted whether or not to perform the repair.

-a

Used in conjunction with -r. Automatically perform database repairs without prompting the user.

-A

Do not issue warnings about Accounts without Users.

-e

Do not check the Allocation records.

-u

Do not issue warnings about Users without Services.

-d days

Check the payhist table only for the last days.

RETURN VALUE

EX_OK if there are no data errors. EX_DATAERR if there are data errors.

Messages about data errors are written to stdout.

NOTES

NONE

SEE ALSO

NONE

Prev  Up  Next
Process a single credit card transaction through the Cybercash processor  Home  dbenv
Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com