Essbase: Validate a database against any errors with Esscmd (Part 1)

You have two options for attempting to validate an Essbase database: Esscmd and Maxl. This post is for using Esscmd.

Esscmd:

admin@epmdbserver:/home/admin>startEsscmd.sh
Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.1.2.2.102B025)
Copyright (c) 1991, 2012, Oracle and/or its affiliates. All rights reserved.

U.S. Patent Number 5,359,724
U.S. Patent Number 6,317,750

:::[0]->login

Login:

Host Node >localhost

User >admin

Password >***********

[Sun Nov 24 11:47:08 2013]Local////Info(1051034)
Logging in user [admin]

Available Application Database:
TestApp ==> TestDB

localhost:::admin[1]-> select TestApp TestDB

select:

localhost:::admin[1]-> validate

validate:

Enter error log file name >./TestDB_error.log

Validate in progress (Hit <Esc> key to cancel).........

[Sun Nov 24 11:51:04 2013]localhost/TestApp/TestDB/admin/Info(1005024)
Validate: no errors found during validation

Validate completed

sts = 0

localhost:TestApp:TestDB:admin[1]->exit

If you had any errors, you can view your log file and correct anything listed.

[ad#ad-post]