http://a1-dba.co.uk/ 2026-04-17T08:14:36+01:00 http://a1-dba.co.uk/ http://a1-dba.co.uk/lib/images/favicon.ico text/html 2017-05-22T12:22:26+01:00 handydba http://a1-dba.co.uk/doku.php?id=start&rev=1495452146&do=diff About The HandyDBA Update May 2017 It's been a long time since this site was updated. My interests and work have moved away from databases into server and web technologies. I'll keep this site alive in the hope that some of the material may prove useful. Alan, See What Did I Learn Today for more up to date articles. text/html 2017-05-22T12:17:19+01:00 handydba http://a1-dba.co.uk/doku.php?id=sidebar&rev=1495451839&do=diff Home Blog About Database administration Operating systems Development Links ---------- Following require login: ScratchPad ---------- ---------- ---------- text/html 2013-06-17T09:54:26+01:00 handydba http://a1-dba.co.uk/doku.php?id=blog&rev=1371459266&do=diff 2013-06-17 SSH Login Banners There are two places where login banners can be configured. What might be less well known are techniques for disabling their display when logging in via SSH ...read 2013-06-03 MySQL In my spare time I do some work for a local charity - which has meant getting up to speed with some new (for me) web and database software. ...read text/html 2013-06-17T09:49:15+01:00 handydba http://a1-dba.co.uk/doku.php?id=blog:201306&rev=1371458955&do=diff 2013-06-17 SSH Login Banners There are two places where login banners can be configured. * The traditional Message Of The Day Typically this is defined in /etc/motd * SSH pre authentication banner. This is displayed before authentication takes place and is typically defined in the site wide SSH config file /etc/ssh/ssh_config by using “Banner /path/to/banner” text/html 2013-03-12T10:37:36+01:00 handydba http://a1-dba.co.uk/doku.php?id=saposcol&rev=1363084656&do=diff saposcol is one of at least two components necessary for collecting SAP performance statistics; e.g. those that can be viewed in ST03G and STAD. On at least two occasions saposcol has failed to start with a shared memory error, e.g. 49>saposcol -l -l 'Can't create shared memory' text/html 2013-03-01T11:16:20+01:00 handydba http://a1-dba.co.uk/doku.php?id=blog:201303&rev=1362136580&do=diff 2013-03-01 SAP Expert Sessions A bunch of recorded Webex sessions hosted by SAP - SAP DB2 expert sessions Watched the system copy optimisation session recently. If you don#t know much about system copy using R3load it's a good view. Some useful information on optimising storage layout and comparison of copy using insert versus load.