tsm: TSM3>select node_name,type,sum(cast(logical_mb/1024 as decimal(10,2))) as Data_In_GB, sum(num_files) as Num_of_files from occupancy group by Node_name,type order by node_name
ANR2958E SQL temporary table storage has been exhausted.
|
V..............................................................
select node_name,type,sum(cast(logical_mb/1024 as decimal(10,2)
ANS8001I Return code 26.
檢查help錯誤訊息，發現DB可能不足
tsm: TSM3>help 2958
-------------------------------------------------------------------------------
ANR2958E SQL temporary table storage has been exhausted.
Explanation: The result of an SQL query could not be computed because temporary
table storage space was unavailable. By issuing the QUERY DB command and viewing
the Maximum Reduction parameter, you can determine the amount of space that is
available for temporary table storage space. If the parameter is less than 4,
the storage space becomes exhausted and the SQL query can no longer run. Complex
SQL queries such as the ORDER BY clause, the GROUP BY clause, and the DISTINCT
operator can cause additional temporary table space to be required.
System Action: The SQL query is terminated.
User Response: If your database is full, increase the size of the database. If
your database is fragmented (Where the Available space parameter is greater than
4, but the Maximum Reduction parameter is less than 4), you must either unload
and load your database or add avolume.
果然DB滿了，這是5版的通病，一直要檢查
tsm: TSM3>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
20,480 10,240 10,240 0 4,096 2,621,440 2,618,403 99.9 100.0
下help看如何擴充db
tsm: TSM3>help extend db
EXTEND DB
EXTEND DB (Increase the Assigned Capacity of the Database)
Use this command to increase the space that can be used by the database in all
allocated database volumes.
Attention: You cannot change the size of an allocated database volume after it
has been defined to Tivoli Storage Manager. If you do, Tivoli Storage Manager
may not initialize correctly and data could be lost.
You can issue the EXTEND DB command while users are accessing the server. Use
the QUERY DB command to determine how much you can increase the assigned
capacity of the database.
Privilege Class
To issue this command, you must have system privilege or unrestricted storage
privilege.
Syntax
>>-EXTend DB--megabytes----------------------------------------><
Parameters
megabytes (Required)
Specifies the space, in megabytes, to be added to the assigned capacity of the
database. The value should be in increments of 4MB. If you do not specify the
extension in 4MB increments, Tivoli Storage Manager rounds the number to the
next 4MB partition.
Examples
Task
Extend the assigned capacity of the database by 52MB.
Command
extend db 52
Related Commands
Table 154. Commands Related to EXTEND DB
Command Description
CANCEL PROCESS Cancels a background server process.
DEFINE DBCOPY Creates a volume copy of a database volume.
DEFINE DBVOLUME Assigns a volume to be used for database storage.
QUERY DB Displays allocation information about the database.
QUERY PROCESS Displays information about background processes.
REDUCE DB Attempts to free up a database volume by reducing usable storage
within the volumes defined.
當時有預留，再擴充5GB
tsm: TSM3>ext db 5120
ANR2248I Database assigned capacity has been extended.
解決
tsm: TSM3>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
20,480 15,360 5,120 5,120 4,096 3,932,160 2,619,105 66.6 66.7
指令正常了
tsm: TSM3>select node_name,type,sum(cast(logical_mb/1024 as decimal(10,2))) as Data_In_GB, sum(num_files) as Num_of_files from occupancy group by Node_name,type order by node_name
NODE_NAME TYPE DATA_IN_GB NUM_OF_FILES
---------------------------------------------------------------- -------------------- --------------------------------- ------------
DELL305 Arch 110.06 345062
DELL305 Bkup 500.84 1095888
DHCP022 Bkup 79.27 294214
DHCP152 Bkup 123.52 144579
tsm: TSM3>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
20,480 15,360 5,120 5,120 4,096 3,932,160 2,619,104 66.6 66.7
tsm: TSM3>q dbv
Volume Name Copy Volume Name Copy Volume Name Copy
(Copy 1) Status (Copy 2) Status (Copy 3) Status
---------------- ------ ---------------- ------ ---------------- ------
/TSMpool1/DB.10- Sync'd Undef- Undef-
G.1 ined ined
/TSMpool1/DB.10- Sync'd Undef- Undef-
G.2 ined ined
tsm: TSM3>q logv
Volume Name Copy Volume Name Copy Volume Name Copy
(Copy 1) Status (Copy 2) Status (Copy 3) Status
---------------- ------ ---------------- ------ ---------------- ------
/TSMpool1/LOG.2- Sync'd Undef- Undef-
G.3 ined ined
/TSMpool1/LOG.2- Sync'd Undef- Undef-
G.1 ined ined
/TSMpool1/LOG.2- Sync'd Undef- Undef-
G.2 ined ined
tsm: TSM3>q log
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
6,144 3,072 3,072 3,068 4,096 785,920 285 0.0 0.1
tsm: TSM3>
