Document Properties
Kbid28957M
Last Modified04-Sep-2019
Added to KB02-Jan-2019
Public AccessEveryone
StatusOnline
Doc TypeSupport Articles
Product
  • ICM 7.6
  • ICM 7.7
  • ICM 7.8
  • ICM 7.9
  • ICM 7.10

Support Article - Check Your Database With our Self-Service

Product Version

7.6

Product To Version


Status

final

1 Introduction

In case you are wondering whether objects are correctly defined in the application's database schema, you can easily check them with our database checkup self-service. It compares your schema with our standard setup, detects missing or non-default objects and - in most cases - also tells you how to fix any problems found.

1.1 References

2 Step by Step

Please log in to support.intershop.de - in your datasheet to the contract you will find a tab named DB Checkup.
Download the gdbix.sql and let it run on the database as described in the script itself. This requires administrative rights on the database.

After execution, an XML is created. You can then upload it on the above page and download an evaluation after a few minutes.
Here you should see if indices, constraints, etc. are standard or missing. Their schema is then compared with that of a standard installation.

Detailed information on the database checkup can also be found in this pdf sheet.

We also offer additional services (Database Review and Database Optimization) on inspecting the database as you can see here.

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources
Support Tickets