Thursday, October 17, 2013

Trouble installing oracle on Windows

So, while installing Oracle on Windows 7 (64-bit), the Oracle installer would just sort of shut down unceremoniously.

I found a log file C:\Program Files\Oracle\Inventory\logs.  It wasn't, however, very revealing.  The last message was simply "INFO: Get view named [QuickInstallUI]"

So, poking around on the internet lead me to a thread over at forums.oracle.com that discussed this issue, but the only thing that worked for me was to create another user and run the install as that user.

Crazy. But it worked.  Wanted to pass it along.

Monday, October 14, 2013

DB2 Backup Naming convention

I had a hard time finding this on the internet, so I thought I'd post after I found it in a book.

The naming convention for a DB2 file system backup will be:
Alias.Type.Instance.Node.Catalog_Node.MonthHourSecond.Sequence
Example:
MyDB.0.DB2INST.NODE00000.CATN0000.20131015131259.001
   ↑       ↑        ↑                ↑                   ↑                ↑   ↑  ↑     ↑   ↑     ↑
Alias     |    Instance          |           Catalog Node     |    |   |      |    |      |
       Backup Type       Node                              Year  |   |      |    |      |
                                                                            Mon  Day  |  Sec   Seq
                                                                                           Min

Reference:
Understanding DB2: Learning Visually with Examples Second Edition
Page 745
14.4.6 The Backup Files
Raul F. Chong Clara Liu Sylvia F. Qi Dwaine R. Snow 

Minimally Logged Operations in SQL Server

I'm posting this mostly so I can find it later :) The following article has a great table that defines when operations will be minimall...