Database Administrators
Profile Activity
Meta user
Network profile
18,693
reputation
2
18
52

Lennart

Spend most of my time in a db2 environment as a DA/DBA. From time to time I also work with other DBMS such as mysql, psql, mssql.

I have a couple of Db2-utilities at github, that you may or may not find useful:

https://github.com/lelle1234/Db2Utils/

  • DBParser, creates ddl for a database. Output is supposed to be in topological order

  • IndexAdvisor, investigates all possible index combinations for a query

748
answers
40
questions
~1.6m
people reached
  • Umea, Sweden
  • lelle1234
  • dustbite.se
  • Member for 6 years, 5 months
  • 1,108 profile views
  • Last seen 4 hours ago

Communities (24)

Top network posts

Top tags (254)

Score 384
Posts 264
Posts % 34
Score 304
Posts 115
Score 228
Posts 143
Score 117
Posts 65
Score 97
Posts 59
Score 85
Posts 47
View all tags →

Top posts (788)

All Questions Answers
Votes Newest
47 NOT (a=1 AND b=1) vs (a<>1 AND b<>1) Apr 6 '17
27 If a database only ever has one insert, is it bad to index every possible column combination? Jun 13 '18
14 Does `COUNT` discard duplicates? Aug 2 '17
12 Does the spec permit column-count mismatch on INSERT? Jan 19 '18
12 What is the optimized way to pass multiple parameter from a single table to a function? Jan 19 '18
10 MariaDB: disable foreign key checks Aug 10 '16
10 Avoiding a divide by zero error in a computed column Jan 6 '16
9 slow select query on datetime column Jan 10 '16
9 How to get the next value of sequence? Jan 21 '16
9 How SELECT column does not list in GROUP BY clause Jun 18 '16
View all questions and answers →

Badges (72)

Gold

2

Rarest

Silver

18

Rarest

Bronze

52

Rarest

View all badges →