Categories
- Availability & disaster recovery
- Business Analytics
- capacity planning
- CIO
- database auditing
- DB2
- DB2 10
- DB2 8
- DB2 9
- DB2 9.5
- DB2 9.7
- DB2 9.8
- DB2 Administration
- DB2 Geek
- DB2 LUW
- DB2 Monitoring
- db2 pureScale
- DB2 Support
- DB2 Tools
- db2 x
- Five days in the labs
- IBM
- IBM Optim
- IDUG
- IDUG EMEA 2010
- IDUG EMEA 2011
- Information Management
- IOD 2009
- IOD 2010
- Iqbal Goralwalla
- James Gill
- Julian Stuhler
- Linux
- optim
- Oracle Vs DB2
- Paul Stoker
- pureScale
- Raj Mahal
- Remote DBA
- System Z
- Techie Tips
- Uncategorized
- Video
- Xkoto
- z/OS
- zTune
Tags
continuous availability data archiving database monitoring data governance data growth management DB2 DB2 9 DB2 9.7 DB2 10 DB2 10 migration DB2 Cobra DB2 Geek DB2 Geeks DB2 LUW db2 migration DB2 monitoring db2 performance db2 pureScale db2 support DB2 Tools db2 v9 DB2 vs Oracle Db2 z/OS DBI Software Gridscale HADR high availability IBM IBM Optim IDUG IDUG EMEA Information Management IOD 2009 Julian Stuhler Mainframe optim oracle Oracle 11g oracle migration pureScale remote DBA System Z Xkoto z/OS z seriesBlogroll
- Channel DB2
- Dangerous DBA
- Database Administration (DBA Blog) Feed
- datagovernanceblog.com
- DB2 for LUW Performance Blog
- DB2 News
- Dwaine Snow's Thoughts on DB2
- Free DB2
- Golden DB2 Updates
- IBM DB2 for z/OS Developerworks Blog
- IBM Information Management
- IBMDatabaseMagazine.com Blogs
- IDUG – International DB2 User Group
- Information Security blog
- Information Technology Risk Management blog
- Nigel Small's Blog
- Planet DB2
- Robin Bloor
- Scott Hayes Blog – DBI Software
- Surekha Parekh’s – a blog about DB2 for z/OS
- System Z Blog from IBM
- The Triton Twitter
- TheKGuy
Meta
Category Archives: Techie Tips
How many DB2 for z/OS Stored Procedure Applications?
As always, the answer to this is “it depends”! However, here are some basic rules of thumb that you may find useful: • Define an application environment specifically for your Java stored procedures. This should have NUMTCB set to a … Continue reading
Posted in DB2, IBM, Information Management, Julian Stuhler, System Z, Techie Tips
Tagged DB2, Java, REXX, stored procedure application, z/OS
Leave a comment
DB2 for z/OS Plan Stability
One of the major headaches all DB2 users face when upgrading to a new release is the possibility of access path regression. In order to benefit from enhancements to the optimiser, plans and packages need to be rebound under the … Continue reading
Posted in DB2, IBM, Information Management, Julian Stuhler, System Z, Techie Tips
Tagged DB2, DB2 8, DB2 9, Mainframe, REBIND, System Z, z/OS
Leave a comment
IP Addresses of Database Connections
Ever needed to track down those pesky connections to a database you’re trying to backup? No idea how to work out who is constantly connected to a database via Command Centre? Well, below is a simple guide to finding out … Continue reading
Posted in DB2, Paul Stoker, Techie Tips
Tagged database connections, DB2, IP Address
Leave a comment
RESTORE.EXE Updated – 64-bit DB2 Support
As the title says, restore.exe (automated redirected restore with TSM support) has been tested against DB2 UDB V8.2 on Windows 2003 Server 64-bit (64-bit instance) and works. Next port will be to Linux 32-bit. Porting to 64-bit will be problematic … Continue reading
Posted in DB2, IBM, Information Management, James Gill, Linux, Techie Tips, Uncategorized
Tagged 64 bit, AIX, DB2, DB2 UDB V8.2, IBM, Linux 32-bit, Solaris
Leave a comment
DB2 9.5 not available for Linux on IA64
For those of you using Linux on the Itanium-64 bit (IA64) platform, note that DB2 9.5 is not available for Linux on IA64. The last supported DB2 version for Linux on IA64 is DB2 9. This is because Linux on … Continue reading
Posted in DB2, DB2 9.5, IBM, Iqbal Goralwalla, Linux, Techie Tips
Tagged DB2, DB2 9.5, IA64, Itanium, Linux
Leave a comment