Mainframe, MVS and zOS Discussion

Hello Anuj,

What do you mean by:

the response time of your LUW gets slow.

Linux, Unix and Windows?

Thanks!
Maidy

What is the best way to partition a table whose primary key is a sequential number? DB2 9 for z / OS

Txs!

My god! It's true!
I was induced for a mainframe analyst, who was saying that the program was a command that he had never seen! And I thought he was right! Sorry guys ...
For me, I would delete this topic.
What a shame!

And yet ...
OPEN ABSORV
FETCH ABSORV INTO :H
CLOSE ABSORV

Hello Guys.

I found a statement in an online program using "DECLARE ABSORV CURSOR".

You know what "ABSORV" is?
This implies the improvement or worsening of performance?

Thanks!!
Maidy

Hello Quasar. Thanks for your consideration!

The REORG TABLESPACE command reorganizes all data and all indexes tied to it.

Txs!
Maidy

Hello People!!

How to know when I need to reorganize tables?
A systems analyst told me that the system performance is poor. And asked me to reorganize tables. How to know which tables should be reorganized without knowing what programs are with the poor performance??

Thanks a lot!!

Thank you Pandora. With your help, I got what I needed.

not, sorryyyyy.... How do I find the status REORG PENDING using the Db2 commands. For tbs and indexes.

tks

Tks Pandora,

I got the following: -DIS DB(*) SPACENAM(*) ADVISORY(AREO*)

Do You know how I do for 'REORG PENDING STATUS'? for tablespaces and indexes?

Tks again!

Hello People!

how can i find a reorg pending status and advisory reorg pending status in catalog tables in db2 z/os?

tks