Dejan's user avatar
Dejan's user avatar
Dejan's user avatar
Dejan
  • Member for 11 years, 2 months
  • Last seen more than 3 years ago
5 votes
1 answer
57k views

ORACLE restore - how to restore specific .bkp file?

5 votes
1 answer
8k views

PostgreSQL - how to list all UNIQUE indexes for specific database?

4 votes
1 answer
10k views

PostgreSQL - do we need to DROP the database and recreate it if we want to RESTORE it?

4 votes
1 answer
211 views

DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)

3 votes
1 answer
744 views

Azure Elastic Pool - is it supported for MySQL?

3 votes
1 answer
4k views

db INDEX on ORDER BY FIELD in very simple query does not help - still slow response?

3 votes
1 answer
4k views

How to create Buffer Pool in Database dedicated only for ONE BIG table?

2 votes
1 answer
2k views

db2 performance issue - large number of IOPS how to determine problem?

2 votes
1 answer
12k views

DB2 Online Restore but Without Roll Forward?

2 votes
1 answer
489 views

Will TRUNCATE stop the increase of the DB2 database size?

2 votes
1 answer
162 views

Issue with one query - can some Index help to make it faster?

2 votes
2 answers
823 views

DB2 - Why new multiple C000000x subfolders are created in Archive Log folder?

1 vote
1 answer
3k views

ONLINE BACKUP is not performed from the CRON Job on LINUX server (manually it works)

1 vote
1 answer
651 views

DB2 Indexes are taking very large size on disk space

1 vote
1 answer
2k views

DB2 - question regarding RESTORE OFFLINE backup and Archive Logs

1 vote
1 answer
6k views

DB2 ROLLFORWARD ERROR when doing "TO A POINT IN TIME" option

1 vote
2 answers
10k views

DB2 ROLLFORWARD option "TO END OF LOGS" - does it read archive logs?

1 vote
1 answer
3k views

PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?

1 vote
1 answer
24k views

MYSQL database how to check if database is active and on which port (Linux)?

1 vote
1 answer
2k views

PostgreSQL logical replication slave - shouldn't it be read-only and available only for subscription updates?

1 vote
1 answer
319 views

Online backups with VENDOR library: what should be set for ACTIVE LOG PATH?

1 vote
1 answer
1k views

DB2 online restore - “SQL1035N The database is currently in use.”

1 vote
1 answer
4k views

Is storing archive logs on local disk and backups on vendor storage possible?

1 vote
1 answer
2k views

DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?

1 vote
1 answer
4k views

DB2 - How to estimate proper BUFFERPOOL size?

1 vote
1 answer
823 views

How to track IOPS statistics?

1 vote
1 answer
495 views

DB2 DBM paramter NUMDB has value 8. Should I change it to 1 because I have only one database?

1 vote
1 answer
3k views

DB2 TRUNCATE command - DROP STORAGE option

1 vote
3 answers
25k views

DB2 ARCHIVE mode - Can all archive logs be deleted after doing the FULL OFFLINE backup?

0 votes
1 answer
2k views

DB2 - What is the difference between online backup and AUTO_DB_BACKUP?