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.

Please follow and like us:

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.