Search

Ramchandra's Weblog

Just ……everything about DB2 LUW

A simple cheat sheet that shows commands every sysadmin managing WebSphere MQ could use

 

http://bencane.com/2013/04/22/websphere-mq-cheat-sheet-for-system-administrators/

Database cannot be opened due to inaccessible files or insufficient memory or disk space

Database ‘db’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Here is Solution/Fix/workaround of this problem.

1. check the DB status, most of the time , it will return 1

use master
select databaseproperty(‘dbname’,’isShutdown’)

2. Change the database to offline to clear the db status

use master
alter database dbname set offline

3. Now change the database to online, at this step log file and data files will be verified by sql server

use master
alter database dbname set online

 

http://sqltrends.blogspot.com/2013/03/database-cannot-be-opened-due-to.html

Recover deleted SQL Server data and tables with the help of Transaction Log and LSNs

some good articles to recover dropped data

http://www.sqlskills.com/blogs/paul/finding-out-who-dropped-a-table-using-the-transaction-log/

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

Registering the Mapped Network Path on SQL Server Management Studio

You, you need to register the mapped network path on the SQL Server Management Studio in order to be able to access the mapped drive from SQL Server Management Studio File Explorer. To do so, open SQL Server Management Studio and execute the query below.

EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘xp_cmdshell’, 1
GO
RECONFIGURE
GO

EXEC XP_CMDSHELL ‘net use N: /delete’
EXEC XP_CMDSHELL ‘net use N: \\ServerName\DB-Backup-ShareName’
EXEC XP_CMDSHELL ‘Dir N:’

How To Compile Kernal in Linux

How To Compile Kernal in Linux

How to Leverage DB2’s Automated Time Travel Queries and Temporal Tables

How to Leverage DB2’s Automated Time Travel Queries and Temporal Tables | MainframeZone.com

IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linx, UNIX and Windows

IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linx, UNIX and Windows – United States

Temporal Tables in DB2 :: IBM Data Management Magazine

Temporal Tables in DB2 :: IBM Data Management Magazine

Best practices: Physical database design for online transaction processing (OLTP) environments

Best practices: Physical database design for online transaction processing (OLTP) environments

Create a free website or blog at WordPress.com.

Up ↑