number of rows selected

[Former Member]

Hi team,

I was asked a question, suppose you are trying to select some data from db6. Now i want to track the progress as to how many rows have been selected is there a way to see.

Since db2top is giving delta information and snapshot we would be running twice.

ConnTime..:	18:23:39.156	UOW Start.:	18:23:39.171	Appl name.:	db2bp	DB2 user..:	DB2SID	OS user...:	db2SID
Agent id..:	27696	Coord DBP.:	0	Coord id..:	199919	Client pid:	15007928	Hash joins:	0
Hash loops:	0	HJoin ovf.:	0	SQL Stmts.:	1	Sorts.....:	0	Sort time.:	0.000
Sorts ovf.:	0	Rows Read.:	571,319,286	Rows Sel..:	0	Read/Sel..:	0	Rows Wrtn.:	0
Rows Ins..:	0	Rows Upd..:	0	Rows Del..:	0	Locks held:	3	Trans.....:	0
Open Curs.:	1	Rem Cursor:	0	Memory....:	192.0K	Dyn. SQL..:	1	Static SQL:	0
Cpu Time..:	337.861791	AvgCpuStmt:	337.861

-+----+----+----+----+----+----+----+----+----+----+----+----+----+-- Dynamic statement [Fetch] -+----+----+----+----+----+----+----+----+----+----+----+----+----+-

Start.....:	18:23:39.180	Stop......:	N/A	Cpu Time..:	337.857589	Elapse....:	0.000107	FetchCount:	0
Cost Est..:	513,582,400	Card Est..:	109,312	AgentTop..:	1	SortTime..:	0	SortOvf...:	0
Sorts.....:	0	Degree....:	1	Agents....:	1	l_reads...:	24,712,153	p_reads...:	194,996
DataReads.:	24,712,153	IndexReads:	0	TempReads.:	0	HitRatio..:	99.21%	MaxDbpCpu.:	0.000000[0]
IntRowsDel:	0	IntRowsUpd:	0	IntRowsIns:	0

db2 "select AGENT_ID,APPL_NAME ,PERCENT_ROWS_SELECTED from sysibmadm.APPL_PERFORMANCE where AGENT_ID=27696"

I am not getting percentage or the number of rows selected.

Whats the best approach to get the number of rows selected for a particular agent id.

[Former Member]

Has anyone tracked the same way ?

[Former Member]

Hi,

You can get this information by executing the below command for the questioned agent id.

$ get snapshot for application agentid <agentID>

you have entries in the output loke below...

Rows read                                   = 0

Rows written                                = 0

Rows deleted                                = 0

Rows updated                                = 0

Rows inserted                               = 0

Rows fetched                                = 0

hope this is what your looking for.

Regards,

Prithviraj

[Former Member]

Hi,

snapshot is not the ideal way since everytime i have to check the progress i will have to see it from the time the job had begun.

I was thinking if there is anyway to check it online while it has been running. Rather than taking snapshot and then again taking a snapshot and calculating the delta.

[Former Member]

Hi,

For real time

If you're running the process through SAP then..

You can check it by double clicking on the workprocess in SM50. You will find the details in there

else if running directly at DB level..

You need to run the command in a script with regular interval and forward the output to a file, everyime appending the output.

Regards,

Prithviraj.