Page 1 of 1
Get Database Param. with Admintools
Posted: Mon Nov 03, 2014 7:44 pm
by usli06
Hi,
Can someone help me with the following command? I thought I'd be able to get the current value for a database parameter like this:
Code: Select all
[dbadmin@vertica11 ~]$ admintools -t database_parameters -d test_db -P ActivePartitionCount
ERROR 3457: Function ActivePartitionCount(unknown, unknown) does not exist, or permission is denied for ActivePartitionCount(unknown, unknown)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
Invalid component input None OR Invalid subcomponent input None
Am I not running the command correctly?
Re: Get Database Param. with Admintools
Posted: Fri Dec 05, 2014 8:35 pm
by JimKnicely
Hi,
That database_parameters admin. tool is used for turning on the debug log. To get a list of components and sub-components query debug_log_help():
Code: Select all
dbadmin=> select debug_log_help();
debug_log_help
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Components: <Sub-Components>
BASICS:<ALL> <BASIC> <INFO> <MEMAUDIT> <TIMING> <WARNING>
CATALOG:<ALL> <BASIC> <INFO> <SESSION> <SNAPSHOT> <WARNING>
COMMAND:<ALL> <BASIC> <INFO> <WARNING>
COMMS:<ALL> <BASIC> <INFO> <INVITE> <MESSAGE> <WARNING>
DESIGNER:<ALL> <BASIC> <DEPLOYMENT> <DESIGNER_LOW> <DESIGNPLANS> <INFO> <INTERNALSTATEMENT> <OVERRIDE> <QUALITYOFDESIGN> <QUERY> <QUERYMANAGER> <QUERYWRAPPER> <STORAGEDESIGN> <THREADCONTEXT> <VIRTUALCATALOG> <WARNING>
DIST:<ALL> <BASIC> <DIST_LOW> <DUMPPLAN> <INFO> <PLANNERDUMPPLAN> <SOCKET> <SOCKETHANDSHAKE> <SOCKET_LOW> <VMPI> <WARNING>
EE:<ALL> <ANALYTICS_LOW> <BASIC> <DELETE> <DELETE_LOW> <DUMPPROFILE> <INFO> <LOAD> <LOCAL_RESEGMENT_LOW> <PHJ> <SENDRECV> <SORT> <TARGET> <TIMEZONES> <UDX_FENCE> <WARNING>
LOCALPLANNER:<ALL> <BASIC> <DUMPPLAN> <INFO> <WARNING>
MAIN:<ALL> <BASIC> <INFO> <INIT> <MEMMGR> <WARNING>
OPT:<ALL> <BASIC> <BUDDYUTIL> <COVERINGPROJECTIONSETMAKER> <DUMPPLAN> <INFO> <JOINORDERMAKER> <JOINORDERMAKER_LOW> <PATH> <PATHFACTORY> <PATHKEEPER> <PATH_LOW> <STAROPT> <STAROPT_LOW> <V2OPT> <WARNING>
OPT2:<ALL> <BASIC> <BUDDY> <COPY> <COSTMODEL> <DISTPLANNER> <DISTPLANNER_LOW> <INFO> <JOINGRAPH> <JOINRANKER> <PHYSICALPROPERTY> <PLAN> <PLAN_LOW> <PREDICATE> <SORTKEY> <WARNING>
OPT3:<ALL> <BASIC> <INFO> <PATHSAMPLING> <WARNING>
PARSER:<ALL> <BASIC> <INFO> <WARNING>
PROC:<ALL> <BASIC> <INFO> <WARNING>
PROTOCOL:<ALL> <BASIC> <INFO> <WARNING>
RECOVER:<ALL> <BASIC> <DUMPPLAN> <INFO> <RECOVERPLANNER> <WARNING>
REFRESH:<ALL> <BASIC> <DUMPPLAN> <INFO> <WARNING>
RESOURCEMANAGER:<ALL> <BASIC> <DISKRESERVATION> <INFO> <QUERYBREAKDOWN> <QUERYREQUESTS> <WARNING>
SAL:<ALL> <BASIC> <INFO> <MEM_MNGR> <WARNING> <WOS>
SESSION:<ALL> <BASIC> <INFO> <WARNING>
SHUTDOWN:<ALL> <BASIC> <INFO> <WARNING>
TM:<ALL> <BASIC> <DUMPPLAN> <INFO> <WARNING>
TXN:<ALL> <BASIC> <INFO> <TXN_LOCK> <WARNING>
UDX:<ALL> <BASIC> <INFO> <WARNING>
UTIL:<ALL> <BASIC> <INFO> <OPTUTIL> <REAPER> <TIMERSERVICE> <WARNING>
VMPI:<ALL> <BASIC> <INFO> <MESSAGE> <WARNING>
(1 row)
Example:
Code: Select all
[dbadmin@vertica01 ~]$ admintools -t database_parameters -d salesdb -P set_debug_log -c CATALOG -s ALL
Turned Debug ON for CATALOG<ALL>