SQL stmt查找表是否处于加载挂起状态? [英] SQL stmt to find if table is in load pending state?
问题描述
如何使用SQL找到表的加载状态,我可以加载
查询表tablename但我不能把它作为一个sql语句来执行。
我想要做的是,我使用java存储的priocedure加载一个
表,现在加载后,我想要通过检查表的状态确保加载完成
如
if(tablestate.equals(" N")))
{继续前进}
其他
在这里休息..
欢迎任何建议......
PS
皮埃尔,因为你已经回答了我之前的两个问题,我认为你也可以为这个问题做好... :-)
How can i find the load state of the table using SQL, i can do "load
query table tablename" but i cannot execute this as a sql statement.
What i want to do is, i m using a java stored priocedure to load a
table, now after loading, i want to make sure load completed
successfully by checking the state of the table
like
if(tablestate.equals("N"))
{proceed forward}
else
break here..
Any suggestions are welcome...
PS
Pierre, since u have answered my previous 2 questions , I assume you ar
egoing to do for this one too..:-)
推荐答案
在SYSTEM MONITOR GUIDE中查看
tablespace_state_change_object_id - 状态变更对象识别< br $>
监视元素
干杯......
Shashi Mannepalli
technocrat写道:
Check this in SYSTEM MONITOR GUIDE
tablespace_state_change_object_id - State Change Object Identification
monitor element
Cheers...
Shashi Mannepalli
technocrat wrote:
如何使用SQL找到表的加载状态,我可以加载
查询表tablename "但我无法将其作为sql语句执行。
我想要做的是,我使用java存储的priocedure加载一个
表,现在加载后,我想确保加载完成
成功通过检查表的状态
如果(tablestate.equals(N))
{继续前进}
其他
在这里打破。 。
欢迎提出任何建议......
PS
皮埃尔,因为你已经回答了我之前的两个问题,我认为你是自愿为这一个做的也..: - )
How can i find the load state of the table using SQL, i can do "load
query table tablename" but i cannot execute this as a sql statement.
What i want to do is, i m using a java stored priocedure to load a
table, now after loading, i want to make sure load completed
successfully by checking the state of the table
like
if(tablestate.equals("N"))
{proceed forward}
else
break here..
Any suggestions are welcome...
PS
Pierre, since u have answered my previous 2 questions , I assume you ar
egoing to do for this one too..:-)
谷歌搜索:db2和快照表fubnctions
你得到to:
http://publib.boulder.ibm.com/infoce...n/t0010418.htm
网址可能包含包含在这个答案中。
查看SNAPSHOT_TBS函数。除其他外,它返回tblsp的
状态。
鉴于它是一个表函数,你可以将它用作SQL。
HTH,Pierre。
-
Pierre Saint-Jacques
SES顾问公司
514- 737-4515
" technocrat" <苏************ @ gmail.com> écritdansle message de news:
11**********************@j33g2000cwa.googlegroups。 com ...
Do a Google search on: db2 and snapshot table fubnctions
You get to:
http://publib.boulder.ibm.com/infoce...n/t0010418.htm
The URL may have wrapped in this answer.
Look at the SNAPSHOT_TBS function. it returns, amongst other things, the
state of the tblsp.
Given it''s a table function, you can use it as SQL.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"technocrat" <su************@gmail.com> a écrit dans le message de news:
11**********************@j33g2000cwa.googlegroups. com...
如何使用SQL找到表的加载状态,我可以加载
查询表tablename。但我无法将其作为sql语句执行。
我想要做的是,我使用java存储的priocedure加载一个
表,现在加载后,我想确保加载完成
成功通过检查表的状态
如果(tablestate.equals(N))
{继续前进}
其他
在这里打破。 。
欢迎提出任何建议......
PS
皮埃尔,因为你已经回答了我之前的两个问题,我认为你是自愿为这一个做的太...: - )
How can i find the load state of the table using SQL, i can do "load
query table tablename" but i cannot execute this as a sql statement.
What i want to do is, i m using a java stored priocedure to load a
table, now after loading, i want to make sure load completed
successfully by checking the state of the table
like
if(tablestate.equals("N"))
{proceed forward}
else
break here..
Any suggestions are welcome...
PS
Pierre, since u have answered my previous 2 questions , I assume you ar
egoing to do for this one too..:-)
OOOPS!
我很抱歉,但snapshot_tbs表函数不会返回表
空间状态。
Mes借口,皮埃尔。
-
Pierre Saint-雅克
SES顾问公司
514-737-4515
" technocrat" <苏************ @ gmail.com> écritdansle message de news:
11**********************@j33g2000cwa.googlegroups。 com ...
OOOPS!
My apologies but the snapshot_tbs table function will not return the table
space state.
Mes excuses, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"technocrat" <su************@gmail.com> a écrit dans le message de news:
11**********************@j33g2000cwa.googlegroups. com...
如何使用SQL找到表的加载状态,我可以加载
查询表tablename。但我无法将其作为sql语句执行。
我想要做的是,我使用java存储的priocedure加载一个
表,现在加载后,我想确保加载完成
成功通过检查表的状态
如果(tablestate.equals(N))
{继续前进}
其他
在这里打破。 。
欢迎提出任何建议......
PS
皮埃尔,因为你已经回答了我之前的两个问题,我认为你是自愿为这一个做的太......: - )
How can i find the load state of the table using SQL, i can do "load
query table tablename" but i cannot execute this as a sql statement.
What i want to do is, i m using a java stored priocedure to load a
table, now after loading, i want to make sure load completed
successfully by checking the state of the table
like
if(tablestate.equals("N"))
{proceed forward}
else
break here..
Any suggestions are welcome...
PS
Pierre, since u have answered my previous 2 questions , I assume you ar
egoing to do for this one too..:-)
这篇关于SQL stmt查找表是否处于加载挂起状态?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!