man, apropos, info, db2 -?

Now You Know How He Knows What He Knew

A long time ago in a POSIX compliant OS far, far away there lived a man and this man was widely regarded for his knowledge. Never, did this man find himself without apropos info . Whether the question was about mounts or how to write a script this man had the answer. That is until one day when this man needed info apropos to the creation of an instance. What should he do?

Having worked previously with command line programs he quickly started jamming keys and pulling his hair. Frustated with the way things worked in his new world he set out to find someone, something, somewhere, where he could go and ask "how do I create an instance, or more specifically how do I ask how do I create an instance?" As he sat there randomly pressing keys trying to remember what he had once read about monkeys and typewriters the following sequence appeared on his screen:


root: /usr/opt/> How can my Muse want subject to invent,
command: How: not found

root: /usr/opt/> While thou dost breathe, that pour'st into my verse
command: thou: not found

root: /usr/opt/> Thine own sweet argument, too excellent
command: Thine: not found

root: /usr/opt/> For every vulgar paper to rehearse?
command: every: not found

root: /usr/opt/> O, give thyself the thanks, if aught in me
command: O: not found

root: /usr/opt/> Worthy perusal stand against thy sight;
command: Worthy: not found

root: /usr/opt/> For who's so dumb that cannot write to thee,
command: who's: not found

root: /usr/opt/> When thou thyself dost give invention light?
command: When: not found

root: /usr/opt/> Be thou the tenth Muse, ten times more in worth
command: Be: not found

root: /usr/opt/> Than those old nine which rhymers invocate;
command: Than: not found

root: /usr/opt/> And he that calls on thee, let him bring forth
command: he: not found

root: /usr/opt/> Eternal numbers to outlive long date.
command: Eternal: not found

root: /usr/opt/> If my slight Muse do please these curious days,
command: my: not found

root: /usr/opt/> The pain be mine, but thine shall be the praise.
command: The: not found

root: /usr/opt/>

DB2 Managed Directories in AIX?

Last night I shot off some scripts that were supposed to dump data into PDFs, and they went off with only a few hitches stemming primarily from my remembering August as a 30 day long month (oops). Nothing I couldn't work around, but the darnedest thing happened. The script after creating the files would then move them to a specified directory, but for some reason they weren't appearing in the destination though they disappeared from the source.

The senior DBA was perplexed, and after perhaps an hour of muttering swear words under his breath, set about to perform tasks other than staring at the directories and navigating around knowing that the script executed and moved the files but they weren't there. Among these tasks was deleting some files in DB2 managed directories. Wouldn't you know after DB2 managed files were deleted from the DB2 managed directories the files created by the scripts magically appeared.

What happened? Well it seems that these script were being moved into DB2 managed directories by AIX, and not by DB2. At least as far I can surmise AIX does not trigger the update of the file tables managed by DB2, and consequently the files remained "unregistered" in their directories until DB2 was stimulated to update the directory tables.