Overview of key DBA features in Toad for DB2 zOS Part XI

Adding Logfiles To add a redo log, the following command is used: ALTER DATABASE database name ADD LOGFILE THREAD y GROUP n (file specification, file specification) SIZE x; or: ALTER DATABASE dat...

Once the application and memory areas have been tuned, the next performance bottleneck can be the disk subsystem. A number of performance indicators can suggest a need to improve Oracle disk I/O. A ma...