User Chris Aldrich

1

15

votes

3

answers

729

views

Transaction Log Backups Serial or Parallel?

May 27 '16 at 15:22 Chris Aldrich 4,796

10

votes

1

answer

69k

views

How do I grant all privileges to local db2admin with DB2 9.7 on Windows?

windows db2 permissions

May 30 '12 at 12:59 Chris Aldrich 4,796

8

votes

1

answer

32k

views

What exactly is binding in DB2?

db2

Jul 1 '15 at 13:07 Chris Aldrich 4,796

3

8

votes

2

answers

5k

views

Is my understanding of Fact table granularity correct?

database-design dimensional-modeling facttable

Oct 22 '14 at 15:41 Community♦ 1

1

7

votes

2

answers

3k

views

Stored Procedures Best Practices: Fenced or Unfenced?

stored-procedures best-practices db2

Jul 28 at 1:01 mustaccio 17.9k

3

7

votes

3

answers

1k

views

Best practices for change management with indexes

index best-practices change-management

Dec 31 '14 at 12:40 Community♦ 1

6

votes

2

answers

31k

views

Cannot connect to DB2 database after restoring an offline backup

restore db2 db2-luw

Dec 18 '18 at 12:02 mustaccio 17.9k

1

6

votes

1

answer

2k

views

Is there a way to edit the System Database Directory for DB2 to remove a database?

db2 windows

Oct 10 '13 at 13:00 Chris Aldrich 4,796

3

5

votes

4

answers

12k

views

What is the purpose of having a table NOT LOGGED INITIALLY

db2 transaction-log ddl

Dec 17 '14 at 16:20 Community♦ 1

5

votes

2

answers

1k

views

Perl vs Ksh for Unix Database Administration

scripting unix

Jan 3 '13 at 20:31 Community♦ 1

2

5

votes

2

answers

2k

views

Isolation Level for a Data Warehouse

db2 data-warehouse isolation-level

Nov 20 '12 at 18:47 Chris Aldrich 4,796

2

4

votes

1

answer

2k

views

What is the best practice for physical deployment of data marts?

best-practices physical-design multi-tenant

Jul 26 '12 at 15:19 Mike Sherrill 'Cat Recall' 9,561

4

votes

1

answer

2k

views

How do I resolve this data source connection issue with Cognos?

db2 configuration cognos iseries

May 16 '12 at 12:48 Chris Aldrich 4,796

4

votes

2

answers

779

views

What is the best practice for mapping from natural keys to integer-based keys? (ETL)

db2 best-practices etl

Mar 30 '11 at 12:55 Chris Aldrich 4,796

2

votes

1

answer

790

views

What are the best practices for ETL of data from one OLTP system to another, Part 2?

best-practices db2 etl

May 11 '11 at 15:53 Community♦ 1

1

2

votes

1

answer

2k

views

What are the best practices for ETL of data from one OLTP system to another?

best-practices db2 etl

May 10 '11 at 14:10 Community♦ 1

1

vote

1

answer

126

views

Is there a way to create a re-usable base table definition in InfoSphere Data Architect?

schema tools ddl scripting infosphere-data-architect

Aug 28 '14 at 19:07 Chris Aldrich 4,796

1

vote

2

answers

835

views

Does anyone use modules in DB2 LUW?

stored-procedures db2 best-practices

Aug 25 '14 at 13:16 AngocA 579

1

vote

1

answer

4k

views

Is there a way to determine automatic storage table spaces?

db2 tablespaces system-tables

Oct 9 '13 at 19:23 mustaccio 17.9k

1

vote

1

answer

3k

views

DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces?

performance db2 best-practices tablespaces buffer-pool

Jul 9 '13 at 14:12 mustaccio 17.9k

1

vote

1

answer

661

views

Should indexes automatically be placed into their own bufferpool?

performance index best-practices db2 buffer-pool

Jul 14 '12 at 9:03 Mat 9,250

0

votes

1

answer

1k

views

How to revoke DBADM and clean up any related objects from DB2 LUW

security db2 best-practices

Dec 2 '18 at 17:11 mustaccio 17.9k

0

votes

1

answer

242

views

Indicators for right balance of the number of DB2 instances per AIX LPAR

db2 best-practices instance

Nov 8 '14 at 6:15 Ian Bjorhovde 1,940

0

votes

1

answer

4k

views

DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?

security db2 best-practices

Aug 13 '14 at 12:41 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

24 Questions

Transaction Log Backups Serial or Parallel?

How do I grant all privileges to local db2admin with DB2 9.7 on Windows?

What exactly is binding in DB2?

Is my understanding of Fact table granularity correct?

Stored Procedures Best Practices: Fenced or Unfenced?

Best practices for change management with indexes

Cannot connect to DB2 database after restoring an offline backup

Is there a way to edit the System Database Directory for DB2 to remove a database?

What is the purpose of having a table NOT LOGGED INITIALLY

Perl vs Ksh for Unix Database Administration

Isolation Level for a Data Warehouse

What is the best practice for physical deployment of data marts?

How do I resolve this data source connection issue with Cognos?

What is the best practice for mapping from natural keys to integer-based keys? (ETL)

What are the best practices for ETL of data from one OLTP system to another, Part 2?

What are the best practices for ETL of data from one OLTP system to another?

Is there a way to create a re-usable base table definition in InfoSphere Data Architect?

Does anyone use modules in DB2 LUW?

Is there a way to determine automatic storage table spaces?

DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces?

Should indexes automatically be placed into their own bufferpool?

How to revoke DBADM and clean up any related objects from DB2 LUW

Indicators for right balance of the number of DB2 instances per AIX LPAR

DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?