http://a1-dba.co.uk/ 2026-05-04T11:41:06+01:00 http://a1-dba.co.uk/ http://a1-dba.co.uk/lib/images/favicon.ico text/html 2011-01-25T11:54:55+01:00 http://a1-dba.co.uk/doku.php?id=blog:201101&rev=1295956495&do=diff 2011-01-25 Did you know #2 DB2 9.5 introduced the db2dsdriver.cfg configuration file to define connection attributes for databases and aliases for databases. By default this file is located in installation_path/cfg but this can be changed by setting the DB2DSDRIVER_CFG_PATH environment variable. text/html 2011-02-15T16:20:28+01:00 http://a1-dba.co.uk/doku.php?id=blog:201102&rev=1297786828&do=diff 2011-02-25 Did you know #4 You can make a connection using SQL Server Windows authemtication using non-Windows authenticated accounts. On the server running the SQL Server instance; Create a local (not domain) user. In SQL Server - create a Windows authenticated user. Make sure the username is prefixed with the server name. For example, if your server name is SVR01 and the username you created was JBloggs then the username you need to create in SQL Server is SVR01\JBloggs text/html 2011-03-01T15:50:01+01:00 http://a1-dba.co.uk/doku.php?id=blog:201103&rev=1298994601&do=diff 2011-03-01 DB2 Workload Uses a single workload setting to configure several registry variables at once, a fine example of this is the 'SAP' workload. DB2 9.7 registry variables - Note that documentation is incomplete List registry variables SELECT SUBSTR(REG_VAR_NAME, 1, 25) AS "REG_VAR_NAME" ,SUBSTR(REG_VAR_VALUE, 1, 15) AS "REG_VAR_VALUE" ,IS_AGGREGATE ,SUBSTR(AGGREGATE_NAME, 1, 15) AS "WORKLOAD_NAME" /** * I Instance * G Global * N Database partition * E Environment … text/html 2011-05-05T14:50:31+01:00 http://a1-dba.co.uk/doku.php?id=blog:201105&rev=1304603431&do=diff 2011-05-05 SQL Server client-side trace Microsoft KB article 929728 describes a situation that can occur in SQL Server 2000 and 2005 when you use SQL Profiler to perform a client-side trace of the events in the instance. Had just this situation today, users had been erporting the instance as performing below it's best for several days. Noticed that many sessions were showing a LATCH_EX wait on resource MISC (42DA8A08). That exactly fits with KB 929278 and we eventually tracked down the trace … text/html 2011-06-22T13:22:57+01:00 http://a1-dba.co.uk/doku.php?id=blog:201106&rev=1308745377&do=diff 2011-06-22 The Golden Rule I can't help but agree with the sentiments expressed by Paul Randall regarding how we behave towards each other. 2011-06-14 Online Backups No, not the ones you do while your database is available. This is about the backups you might do to an internet storage provider. text/html 2011-07-29T16:09:59+01:00 http://a1-dba.co.uk/doku.php?id=blog:201107&rev=1311952199&do=diff 2011-07-29 VirtualBox 4.1 Virtualbox 4.1.0 is available for download. Make sure you also download and install the extension pack for 4.1 before you touch any of your existing VM's. That said, I haven't had any problems opening VM's created in previous versions with 4.1 so far. text/html 2011-08-26T15:53:05+01:00 http://a1-dba.co.uk/doku.php?id=blog:201108&rev=1314370385&do=diff 2011-08-26 Windows 7 User Account Control (UAC) When logging on to Windows 7 as a user that is a member of the Administrators group your user token is split into two tokens; a full administrator token and a standard user token. The latter token is used to start the desktop (explorer.exe) and as all applications inherit their access control from the desktop they all run as standard user. text/html 2011-09-29T10:12:37+01:00 http://a1-dba.co.uk/doku.php?id=blog:201109&rev=1317287557&do=diff Must try to get more of my notes, etc. here 2011-09-29 Ayrton Senna We've had a couple of quotes from Ayrton Senna (see left sidebar). Some of his quotes relate to his qualifying laps at Monaco in 1988. The laps he describes with a couple of sentences were breathtaking to watch. text/html 2011-11-15T10:04:39+01:00 http://a1-dba.co.uk/doku.php?id=blog:201110&rev=1321351479&do=diff 2011-10-07 Did you know #6 In SQL Server, you can easily find details for an object by querying the local sysobjects table. To find an object in all databases on a server you can use sp_MSforeachdb, e.g. 1> exec sp_MSforeachdb "Select '?' as dbname,* From [?]..sysobjects where name like '%55111Q%'" 2> go text/html 2012-01-09T17:26:01+01:00 http://a1-dba.co.uk/doku.php?id=blog:201111&rev=1326129961&do=diff 2011-11-17 DB2 server authentication and file permissions On one of our DB2 servers users recently started seeing errors similar to this: db2 => connect to bq1 user sapr3 Enter current password for sapr3: SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001 text/html 2012-03-07T08:34:14+01:00 http://a1-dba.co.uk/doku.php?id=blog:201203&rev=1331109254&do=diff 2012-03-07 The perils of assuming DDL behaviour in one RDBMS translates to another Here's the scenario: Two tables in a DB2 database, SAP expecting a PK constraint to be on TABLEA but instead the constraint and associated index exists on TABLEB. (The reason behind this is a story for another time). text/html 2012-04-19T14:43:03+01:00 http://a1-dba.co.uk/doku.php?id=blog:201204&rev=1334842983&do=diff 2012-04-11 Scheduling background jobs in SAP The scheduler supplied by SAP is capable of time and event based scheduling. Time based scheduling can be described as basic, it can not, for example, schedule a job that runs every 15 minutes on every work day between 10a.m. and 4:45p.m. We are in the middle of a SAP implementation and had a need for a scheduler that could schedule such a job. Our implementation consultants suggested we add ABAP code to each job to handle this requirement. G… text/html 2012-05-03T13:08:24+01:00 http://a1-dba.co.uk/doku.php?id=blog:201205&rev=1336046904&do=diff 2012-05-03 Powershell and database monitoring I like Powershell, a lot; it makes Windows worth using (for me anyway). For a variety of reasons my current work environment uses Oracle, DB2 and SQL Server and, given the correct client software is installed, Powershell can connect to all of them. text/html 2012-07-13T16:14:48+01:00 http://a1-dba.co.uk/doku.php?id=blog:201207&rev=1342192488&do=diff 2012-07-13 Removed files but filesystem usage still 100% One filesystem dedicated to Oracle exports. This system has been around for many years and filesystem usage is generally around 75%. Normally, export files are created, written to tape and then deleted. text/html 2013-02-15T11:55:51+01:00 http://a1-dba.co.uk/doku.php?id=blog:201301&rev=1360929351&do=diff 2013-01-08 Use db2pd to get table usage statistics For example: Use this to get the top 5 tables in terms of rows inserted. $ db2pd -db ed1 -tcbstats | awk '/TCB Table Stats/ { found=1 } found==1 { print }' | awk '/^0x/ { print $11,$12,$13,$2 }' | sort -rn | head -5 66952378 0 66952378 SMENSAPT 50779560 11070 49599240 SYSCOLDIST 16985688 0 16985688 SMENSAPNEW 14499524 0 0 HIST_SNAPDBMEM 7983536 0 8017280 CCSELKEY text/html 2013-02-15T13:09:12+01:00 http://a1-dba.co.uk/doku.php?id=blog:201302&rev=1360933752&do=diff 2013-02-15 SAP DB2 9.7 recommended parameters [SAP Note 1329179] documents the parameter settings SAP recommend for DB2 9.7. Alexander Seelert has put together a useful tool that will take these recommendations along with a few inputs (like database ID) and generate all the required DB2 update statements. text/html 2013-03-01T11:16:20+01:00 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. text/html 2013-06-17T09:49:15+01:00 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 2012-04-13T12:33:24+01:00 http://a1-dba.co.uk/doku.php?id=blog:sapworkload&rev=1334316804&do=diff When SAP is installed the 'SAP' workload will be created. Documentation for some of these variables is ... sparse. Where '????' appears I haven't so far been able to find any documentation on the parameter and/or the value it is being set to. -- Request either reduced optimization features or rigid use of optimization features at the specified optimization level DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF -- List prefe…