Ben Berry

Author's details

Name: Ben Berry
Date registered: December 11, 2015
URL: http://www.humbletown.org

Latest posts

  1. List all base tables in a DB2 database — August 18, 2017
  2. List unreferenced tables in a DB2 database — August 18, 2017
  3. Installing notepadqq on Debian-based Linux — May 29, 2017
  4. Making a replacement lathe leadscrew nut — January 9, 2017
  5. Windows Symbolic Links — December 6, 2016

Most commented posts

  1. In the beginning… — 2 comments
  2. All-terrain Mobility Scooter, Part 4 — 1 comment
  3. List tables without Primary Keys in a DB2 database — 1 comment

Author's posts listings

Aug 02

List Active Directory groups for a user

Paste this code into a PowerShell: (New-Object System.DirectoryServices.DirectorySearcher(“(&(objectCategory=User)(samAccountName=myUserID))”)).FindOne().GetDirectoryEntry().memberOf

Jun 06

Generating DB2 RUNSTATS SQL

This SQL will generate a set of RUNSTATS commands for the tables in your database that have no RUNSTATS values recorded. select ‘CALL SYSPROC.ADMIN_CMD(”RUNSTATS ON TABLE ‘|| trim(tabschema) || ‘.’ || tabname || ‘ ON ALL COLUMNS AND INDEXES ALL ALLOW READ ACCESS”);’ from syscat.tables where stats_time is null and tabschema not like ‘SYS%’ order …

Continue reading »

Apr 26

Installing Python3/Spyder on Linux Mint 17

sudo apt-get install python3-pip python3-pyqt4 sudo pip3 install spyder sudo pip3 install rope

Apr 11

List tables without Primary Keys in a DB2 database

— — List DB2 base tables which don’t have Primary Keys — SELECT sit.TABLE_NAME, ‘No Primary Key’ FROM SYSIBM.TABLES sit LEFT OUTER JOIN SYSIBM.SYSCOLUMNS sic ON sic.TBNAME = sit.TABLE_NAME AND sic.KEYSEQ > 0 WHERE sit.TABLE_SCHEMA = ‘@MVPADM’ AND sit.TABLE_TYPE = ‘BASE TABLE’ AND sic.NAME IS NULL;

Dec 30

Plastic recycling

plastic011

From time to time I need a big lump of plastic to construct something in my workshop.  Suitable pieces are usually either difficult to find or expensive, so I’ve been looking for alternatives which preferably use material which would otherwise go to landfill. After watching this video about recycling HDPE (#2) plastic, I bought a …

Continue reading »

Dec 11

In the beginning…

VirtualBoxDRDOS7

…we needed a starting post which included an image file, just to prove that it would work. So here’s a screen shot of Microsoft Excel, running under Windows 3.1, on DR DOS 7,  inside VirtualBox, on a Linux machine.

» Newer posts