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...

SQL Server 2005 Instance will not start after moving MSDB and MODEL data and log files. SQL Server 2005 Standard edition SP3 and CU4 (x64) on Windows 2008R2 I installed 2 instances on this Server. I then proceeded to move the Master, Model and MSDB data and log files from their original...

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"...

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...

I have a SQL Server 2005 Server (32bit) running SQL Server 2005 Standard Edition and SP3. The Server is a 4 Processor box (Two Dual core CPU's) - each processor at 2.87 GZh I have 16MB of RAM and three Instances running - one Default and two named. In my default instance only, I have been...

I am running DB2 z\OS (mainframe) V9 and DB2 (UDB) on Windows V9.5 I am using an in-house query tool which has a DataCompare feature to compare a table on the mainframe which was recentely copied down to UDB. Here is the DDL for the table...

Not sure if I can explain this adequately but here goes... We are having a peculiar problem when certain users attempt to Select against certain IBM DB2 V9 Mainframe tables via a query tool that we use called AQT we get this error: 40003(-30073)[IBM][CLI Driver][DB2] SQL30073N "0x0000"...

MS SQL Server 2005 sp2 These two errors are filling up my sql server and Server level application even log?? Cannot add or update Activity record because Account Owner does not exist. Error: 250071, Severity: 16, State: 1. Any ideas?

I have a 32 bit Windows 2003 Server Enterprise Edition Server with one quad core processor 2.83ghz and the box has 3.25 GB of RAM. Is this adequate to run one default and two Named Instances of SQL Server 2005 Standard Edition (patched to SP3) ?? If additional memory is recommended, what...

I have a Windows Server hosting our SQL Server 2005 (Standard Edition) Databases. I have a Default and two named instances and I need to add a third named instance. These are the steps I am taking : Run SQL Server 2005 Setup accept licensing agreement. Installing prerequisites - required...

I am in kind of a bind. Every week I restore our production Database into a different database on a different Server for viewing by the users. Both Server are Windows boxes running V9.5 Usually a just do a redirected restore but the datbase is growing by eaps and bounds so this week I...

I have an old DB2 V7 Instance with 6 Databases that we are upgrading to V8 and then to V9. I installed (on a new server) workgroup server edition V8 buildlevel: Product identifier SQL08010 Level identifier 01010106 Level DB2 v8.1.0.36 Build level s021023 Now I am trying to bring this instance...