List of Contributions

Martin Ålund

Contact Details

My Content

1 to 13 of 13 total
Posted By Martin Ålund Tue September 26, 2023 08:54 AM
Found In Egroup: Db2 for z/OS & Db2ZAI
\ view thread
Hi Steve You are not entirely right. To change the DSSIZE for a single partition the tablespace has to be defined with PAGENUM RELATIVE. It is not enough that it is UTS PBR. On the other hand if it has PAGENUM RELATIVE you can increase the DSSIZE very smoothly with an ALTER. That saved me lots of ...
Posted By Martin Ålund Tue September 26, 2023 02:12 AM
Found In Egroup: Db2 for z/OS & Db2ZAI
\ view thread
Hi Donna We have a few tablespaces that big and we have reorged them with SHRLEVEL REFERENCE and SHRLEVEL CHANGE. You cannot use SHRLEVEL NONE to materialize a pending definition change, for example converting to pagenum relative. I would never recommend anyone to use REORG SHRLEVEL NONE by the ...
Posted By Martin Ålund Tue October 19, 2021 12:02 PM
Found In Egroup: Db2 Tools for zOS
\ view thread
It liked the exchange. Some questions where a bit to complex to reply to properly. I would absolutely do it again. ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 12:00 PM
Found In Egroup: Db2 Tools for zOS
\ view thread
We manually found out that the view was the problem. But we needed index advisor to find out wihich index was missing. If I remember it right the missing index led to scanning one 80 k row table 500 times for every execution. It was dynamic SQL, but we ran index advisor on the view itself. --- ...
Posted By Martin Ålund Tue October 19, 2021 11:50 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
We went from "not possible to run" to "execution within milliseconds". It took us about an hour to solve the problem. Most of the time spent came from figuring out how to find the problem. When we realised that we could use Data Studio we found and solved the problem in minutes. ------------------------------ ...
Posted By Martin Ålund Tue October 19, 2021 11:47 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
We need IDAA Admin ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:39 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
We accessed several tables thru a complex view. Thanks to index advisor we found out which index was missing ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:37 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
Cobol - IBM Developer for z Java - I really do not know ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:34 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
We didn't get Optim Query Worklload Tuner to work properly, so we just use Visual Explain, statistics advisor and index advisor ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:32 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
They are written by developers and DBAs. We try to get the developers to write all of them. Most of the new ones are Native SQL Procedures. We also use Cobol Stored Procedures for special purposes. ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:28 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
We are adopting agile development practices and it extends to z/OS applications, both Cobol and Java ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:25 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
Visual Explain Building and testing Stored Procedures Administering IDAA ------------------------------ Martin Ålund ------------------------------
Posted By Martin Ålund Tue October 19, 2021 11:20 AM
Found In Egroup: Db2 Tools for zOS
\ view thread
Sysprogs (for administering IDAA), DBAs and developers ------------------------------ Martin Ålund ------------------------------