 |
 |
Archives of the TeradataForum
Message Posted: Thu, 06 May 2004 @ 17:43:44 GMT
| Subj: | | Spool Usage without Session |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, May 06, 2004 13:29 -->
Hi All,
Anyone know how a user could have current spool usage if the user has no current session logged on? I have that as shown by the below BTEQ
results where user has current spool but no session. In our diskspace history table, this user has this same current spool usage every hour of
every day going back to early April. I greatly appreciate any ideas how this can be or how to fix it.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
Select *
From DBC.sessionInfo
Where username = 'fryer';
*** Query completed. No rows found.
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
Select vproc, databasename, currentspool
From DBC.DiskSpace
Where databasename = 'fryer';
*** Query completed. 16 rows found. 3 columns returned.
*** Total elapsed time was 4 seconds.
Vproc DatabaseName CurrentSpool
------ ------------------------------ -------------------
0 fryer 0
1 fryer 0
2 fryer 1,433,570,816
3 fryer 1,411,943,424
4 fryer 0
5 fryer 0
6 fryer 1,410,153,984
7 fryer 1,410,483,712
8 fryer 1,417,439,744
9 fryer 1,419,947,520
10 fryer 0
11 fryer 0
12 fryer 1,391,145,472
13 fryer 1,405,389,312
14 fryer 0
15 fryer 0
Thanks!
| |
