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
|