Hi,
There is this hot news in note 1347302,
a.) I wonder how many of you manage to run the SQL ?
b.) How do I execute the long sql statement in as/400 green screen ? As per the steps mentioned i save the long statement in a file "tbsp_size_issue.sql" and store in /home , then i execute
qsh db2 -tvf "/home/tbsp_size_issue.sql"
Then i got below message
EXECUTING: select t1.tbsp_name, t1.tbsp_id, t1.tbsp_total_pages, ( t
1.tbsp_total_pages * ( t0.tbsp_page_size / 1024 ) ) as tbsp_total_
size_kb, t1.tbsp_page_top, ( t1.tbsp_page_top * ( t0.tbsp_p
age_size / 1024 ) ) as tbsp_hwm_kb, t0.tbsp_page_size, t1
.dbpartitionnum from sysibmadm.snaptbsp t0, sysibmadm.snaptbsp_part t1 wh
ere t0.tbsp_name = t1.tbsp_name and t0.dbpartitionnum = t1.dbpartiti
onnum and ( ( t1.tbsp_total_pages * ( t0.tbsp_page_size / 1024 ) )
> ( 0.9 * power( bigint( 2 ), 32 ) ) or ( t1.tbsp_page_top * ( t
0.tbsp_page_size / 1024 ) ) > ( 0.8 * power( bigint( 2 ), 32 )
) ) order by t1.tbsp_name, t1.dbpartitionnum
CLI ERROR *****
SQLSTATE: 42601
NATIVE ERROR CODE: -199
Keyword FROM not expected. Valid tokens: (.
c.) In the notes, it mention we can execute SQL in tcode DBACOCKPIT also, but i don't find the "SQL command" entry for me to put the SQL statement. Anyone executed SQL in DBACOCKPIT before ?
Please advise.
Your comment and advise will be appreciated.
Thanks.
Regards,
Kent