Search results for query: *

Running DB2 LUW V9.7 on Windows and I'm having a hard time understanding how "Select Access to PUBLIC" works. We have Select Access Granted to the PUBLIC role for most of our tables in the Database. How does the user actually gain the access? By membership in a particular Active Directory...

DB2 LUW V9.7 on Windows. We had a Database dropped some time ago and I need to know if there is anyway to query against the Instance to get the Backup history for this dropped database.

We are running SQL Server 2008 R2 in an Active\Passive Cluster on Windows 2008R2. We now have the need to recover this Server and it's Databases at our Disaster Recovery site. We will NOT be setting up the Cluster at the Disaster Recovery site, only a standalone Server which we will recover...

I am running Veritas Netbackup\Netbackup MS SQL Client Version 7.0 the task at hand is to tape a recent backup of the CR_Reporting Database on SQL server KOCSQL01\Towerprod and restore it to Database CR_Reporting on SQL Server KOCSQLLAB02\TOWERTEST. I created this restore script for...

Attemping to restore a backup made on one MS SQL Server 2005 Instance and restore to another. Here is my script: # OPERATION RESTORE OBJECTTYPE DATABASE RESTORETYPE MOVE DATABASE "ORION" # # Replace the file path <F:\MSSQL\KOCSQLDEV02\Default\Datafiles\Orion.mdf> # with a new file...

Looks like I had a typo in my Alter Database commands. I started up in single user mode and reissued my commands correctly like this and the instance started up just fine: USE master; GO ALTER DATABASE MSDB MODIFY FILE (NAME = msdbdata, FILENAME = 'E:\Microsoft SQL...

Looks like I had a typo in my Alter Database commands. I started up in single user mode and reissued my commands correctly like this and the instance started up just fine: USE master; GO ALTER DATABASE MSDB MODIFY FILE (NAME = msdbdata, FILENAME = 'E:\Microsoft SQL...

...G:\MSSQL\KOCSQL06\Default\LogFiles for the log files. I moved master using the configuration manager and moved model and msdb using this SQL: **MOve MSDB** USE master; GO ALTER DATABASE MSDB MODIFY FILE (NAME = msdbdata, FILENAME = 'F:\MSSQL\KOCSQL06\Default\Datafiles\msdbdata.mdf'); GO...

I missed that second link :) That helps alot!! Thank you!

What we have done is not added something new but changed some of the existing entries moved a couple of nodes to different systems and databases to different nodes.. I would have thought that with these types of changes that I would either have to flush DIR_Cache or Stop\Start DB2?

All I found on this link was this: "When Freed: When an the application process terminates, the application directory cache is freed When a database manager instance is stopped (db2stop), the server directory cache is freed. " so i guess what that means is evertime you catalog something new...

We are running DB2 Connect Version v8.1.7.445 DB2 Connect is our passthru for the Distributed world to be able to talk to the mainframe databases. We make infrequent changes to what Mainframe Databases are cataloged in DB2 Connect but when we do, we need the changes to be immediate. What I...

I have a data conversion to tackle. They are moving from a Windows to a Linux platform on the application side (this is a website deployment app) . The database contains many tables with a PATH column. The path column references the location of a file on the deployment server. Because we are...

I have an MSDN subscription. WHen I download Windows 7 and use Nero or IMG Burn to write the ISO file to the CD\DVD, I end up with a bootable DVD. When I download windows XP or any of the other operating systems and burn the ISO to a CD\DVD, I do NOT get a bootable disk. Can anyone tell me...

Here is my DB2 Version (UDB on Windows) Product identifier SQL09052 Level identifier 03030107 Level DB2 v9.5.201.346 Build level s080911 PTF WR21421 -- We have been having a problem with the Health Monitor. the Mon_Heap_sz was too small and the instance crashed. upped the Mon-heap_sz from 66...

Running three Databases on the following DB2 Instance: (this is on a Windows 2003 Enterprise edition Server) C:\>db2level DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08028" with level identifier "03090106". Informational tokens are "DB2 v8.1.15.254", "s070720", "WR21383"...

DUH!! I see now that I have to plug in my variables.. etc.. I will work on this and let you know how I make out :)

Thanks :) Guess I'm not understanding how this works.. I execute it and it returns one row but does not change anything.. Column 1,Column 2,Column 3,Column 4,Column 5,Column 6 templatedata\Article\ColumbiaArticle\data\2002-01_wuerl_en,templatedata \Article\ColumbiaArticle...

Question for the SQL gurus.... I'm researching a Data Conversion. I've included the Table DDL and some sample Data (current data and expected results data) The PATH column is the Primary Key. Example Contents of Path column templatedata\Article\ColumbiaArticle\data\2004-09_Spalding_en...

Thank you for your reply.. I didn't think about a bad memory stick!!!! I ruled out a bad drive in the array and most configuration problems except the tempdb. Since the error always points to Database ID 2 - which is Tempdb - and I am ONLY seeing the error in the default instance.... I was...