SQL Administration API Functions

From OnManager
Jump to: navigation, search
  • add bufferpool argument: Add a new buffer pool
  • add log argument: Add a new logical log
  • add memory argument: Increase shared memory, (onmode and a arguments)
  • add mirror argument: Add a mirror chunk
  • alter chunk argument: Change chunk status to online or offline, (set chunk argument)
  • alter logmode argument: Change the database logging mode
  • alter plog argument: Change the physical log
  • check data argument: Check data consistency
  • check extents argument: Check extent consistency
  • checkpoint argument: Force a checkpoint, (onmode and c arguments: Force a checkpoint)
  • clean sbspace argument: Release unreferenced smart large objects
  • create blobspace argument: Create a new blobspace
  • create chunk argument: Create a new chunk - with_check option, (add chunk argument)
  • create dbspace argument: Create a new dbspace
  • create sbspace argument: Create a new sbspace
  • create tempdbspace argument: Create a temporary dbspace
  • drop blobspace argument: Drop a blobspace
  • drop chunk: Drop a chunk
  • drop dbspace argument: Drop a dbspace
  • drop log argument: Drop a logical log
  • drop sbspace argument: Drop an sbspace
  • drop tempdbspace argument: Drop a temporary dbspace
  • ha set primary argument: Define an HDR primary server
  • ha set secondary argument: Define an HDR secondary server
  • ha set standard argument: Convert an HDR server into a standard server
  • onmode and C arguments: Control the B-tree scanner
  • onmode and D arguments: Set PDQ priority (set onconfig arguments)
  • onmode and e arguments: Change usage of the SQL statement cache
  • onmode and F arguments: Free unused memory segments
  • onmode and j arguments: Switch the database server to administration mode
  • onmode and l arguments: Switch to the next logical log
  • onmode and m arguments: Switch to multi-user mode
  • onmode and M arguments: Temporarily change decision-support memory (set onconfig arguments)
  • onmode and n arguments: Unlock resident memory
  • onmode and O arguments: Mark a disabled dbspace as down
  • onmode and p arguments: Add or remove virtual processors
  • onmode and Q arguments: Set maximum number for decision-support queries (set onconfig arguments)
  • onmode and r arguments: Force residency of shared memory
  • onmode and S arguments: Set maximum number of decision-support scans (set onconfig arguments)
  • onmode and W arguments: Reset statement cache attributes
  • onmode, wm, and AUTO_LRU_TUNING arguments: Change LRU tuning status
  • onmode and Y arguments: Change query plan measurements for a session
  • onmode and z arguments: Terminate a user session
  • print error argument: Print an error message
  • print partition argument: Print partition information
  • rename space argument: Rename a storage space
  • reset sysadmin argument: Move the sysadmin database
  • restart listen argument: Stop and start a listen thread dynamically
  • scheduler argument: Stop or start the scheduler
  • set onconfig memory argument: Temporarily change a configuration parameter, (onmode and wm arguments)
  • set onconfig permanent argument: Permanently change a configuration parameter, (onmode and wf arguments)
  • set sbspace accesstime argument: Control access time tracking
  • set sbspace avg_lo_size argument: Set the average size of smart large objects
  • set sbspace logging argument: Change the logging of an sbspace
  • set sql tracing argument: Set global SQL tracing
  • set sql tracing database argument: Change database tracing
  • set sql tracing session argument: Control tracing for a session
  • set sql tracing user argument: Control tracing for users
  • start listen argument: Start a listen thread dynamically
  • start mirroring argument: Starts storage space mirroring
  • stop listen argument: Stop a listen thread dynamically
  • stop mirroring argument: Stops storage space mirroring
  • enable compression argument: Enable compression of a table or table fragment
  • table or fragment arguments: Compress data and optimize storage
  • Purge compression dictionary arguments: Remove compression dictionaries