DatabaseJournal.com Staff

>>Script Language and Platform: MSSQL/VBScript This VBScript can be used to delete old folders. ‘Usage: DeleteOldFolder “\Servername1SharenameReplication” “3” “\servername2logDeleteOldFolders.log” ‘Usage: DeleteOldFolder “d:MSSQLBACKUPReplication” “2” “C:mylog.txt” Author: MAK ‘Objective: To Delete folders older than certain # of days. ‘Created by: MAK ‘Date Written: Jun 4, 2004 ‘Usage: DeleteOldFolder “\Servernamed$MSSQLBACKUPReplication” “2” “C:mylog.txt” ‘Usage: DeleteOldFolder “\Servername1SharenameReplication” “3” “\servername2logDeleteOldFolders.log” On […]

[From Oracle Corp.] REDWOOD SHORES, Calif., Jun. 16, 2004 – (http://www.oracle.com/tellmemore/?3196358) Acucorp, Inc., a leading provider of legacy application modernization and extension solutions, and Oracle Corp. today announced they are offering companies the tools to facilitate migration of legacy assets from proprietary legacy platforms to a wide range of open, less expensive computing platforms. Acucorp’s […]

[From Lumigent Technologies, Inc.] ACTON, Mass. – June 15, 2004 – Lumigent Technologies, Inc., developer of award-winning data auditing solutions, today unveiled Entegra™ for Oracle® databases. This enterprise-level software helps organizations maintain the integrity of their data, reduce the risk of inappropriate changes and access to data, and meet compliance regulations. Data auditing solves today’s […]

[From Computerworld] The judge overseeing the U.S. government’s case to block Oracle Corp.’s proposed takeover of PeopleSoft Inc. has grown weary of the amount of material being filed under seal and is pushing both sides to make more information public. “It does appear to me it has gotten out of hand,” Judge Vaughn Walker told […]

[From MSDN] This first in a series of articles by Michael Rys details the major new capabilities of the server-side FOR XML clause in the next version of SQL Server. These enable you to further enhance the XML support in your applications and to write easy-to-maintain relational data-to-XML aggregations. (12 printed pages) The article continues […]

[From internetnews.com] The worldwide market for database software appears to be on a comeback, as total revenues reached $13.6 billion in 2003, improving slightly from 2002, according to the latest figures from market research firm IDC. The market rebounded from a sluggish 2002 when revenues totaled only $12.6 billion and the niche declined for the […]

Siva Muthuraman When we were in the process of implementing RMAN backups for our databases, we felt that there were not many articles or real stories on how someone survived a real disaster. This article walks through a real disaster we recently had in our company and how we survived it using RMAN backups. This […]

by Roman B. Melnyk and Paul C. Zikopoulos The technology preview of the next release of IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX , and Windows is codenamed “Stinger”. As of the publication date of this article, it is available as an open beta for download at: http://www.ibm.com/data/stinger. This article is another in […]

by Paul C. Zikopoulos and Roman B. Melnyk The next release of IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX , and Windows is codenamed “Stinger.” As of the publication date of this article, DB2 UDB “Stinger” is available as an open beta for download at: www.ibm.com\data\stinger.’ In a previous article, we detailed some […]

by Paul C. Zikopoulos and Roman B. Melnyk DB2 UDB “Stinger” is the technology preview of the next release of the IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX , and Windows . As of the publication date of this article, it is available as an open beta for download at: www.ibm.com\data\stinger. DB2 UDB […]

>>Script Language and Platform: Oracle Each transaction will be put in the v$transaction table. This query will give you which rollback segment they are using and how much. It will also show how much temp space they are using. If the column STATUS shows up “ACT” the statement is currently running, if it shows up […]

>>Script Language and Platform: Oracle The v$session_longops table is an excellent table to determine how long a statment will run. This query will give the the current operation and its target. The biggest feature of this query is that it shows the I/O rate of the operation. Author: Shawn Ellinger column ssid format 9999 heading […]