Category: PowerShell

f8259cc09326948fe0d3a93567a9fcc2 5

How to Get a List of Local DB2 Databases

The database directory is something many of us use every day. It includes informaiton for connecting to databases, both local and remote, as well as additional information like alternate servers and filesystems where database directories reside. Getting just the local database names out of it may take a bit of practice. Please use the code here cautiously, after thorough testing,...

shell1 5

PowerShell for DB2 DBAs – Part 1

Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload.  Of course, the benefits of scripting do not end there.  This post is intended to be the first of a planned series with a goal to show how PowerShell...