The RESET statement resets ALLBASE/SQL accounting and statistical
data.
Scope |
 |
ISQL or Application Program
SQL Syntax |
|
RESET {SYSTEM.ACCOUNT [FOR USER {*
DBEUserID}]
SYSTEM.COUNTER } |
Parameters |
|
- SYSTEM.ACCOUNT
is specified to reset accounting data for one user's
DBE session or for all active sessions.
- *
specifies all active sessions. This is the default
if the FOR USER clause is omitted.
- DBEUserID
identifies the user of a specific DBE session.
- SYSTEM.COUNTER
is specified to reset ALLBASE/SQL statistical counters.
Description |
|
Refer to the ALLBASE/SQL
Database Administration Guide for more information about
the SYSTEM.ACCOUNT and SYSTEM.COUNTER views.
Authorization |
|
You must have DBA authority to use this statement.
Example |
|
The I/O resource usage for NewUser's current database session
is set to zero.
RESET SYSTEM.ACCOUNT FOR USER NewUser |
