Infrastructure at your Service

 
Gérard Wisson

Documentum upgrade project – Documentum Administrator and ACS

By | Application integration & Middleware | No Comments

After having installed the Documentum Administrator, one of our test was to open a document. When I opened one for the first time the content was empty although I knew it contained text. But the correct content was well displayed when I opened it a second time. In the ucf trace file I had: FINE: [email protected] pairs: {null: HTTP/1.1 500 Internal Server Error}{Server: Apache-Coyote/1.1}{Content-Type: text/html;charset=utf-8}{Content-Length: 3437}{Date: Mon, 27 Jan 2014 12:55:47 GMT}{Connection: close} Jan 27, 2014 1:55:47…

Read More
Gérard Wisson

Documentum upgrade project – D2EventSenderMailMethod & bug with Patch 12

By | Application integration & Middleware | No Comments

We started the Documentum upgrade in the wintertime and our jobs ran successfully by following the defined schedule. Once we moved to the summertime we hit an issue: A job that was scheduled for instance at 4:00 AM was executed at 4:00 AM, but also started every 2 minutes until 5:00 AM. We had this issue on all our 6.7SP2P009 repositories – on upgraded as well as on new repositories. Before opening an SR in…

Read More
Oracle Team

Oracle: How to move OMF datafiles in 11g and 12c

By | Database management, Oracle | One Comment

By Franck Pachot . With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in 12c. And how to do it with minimal downtime in 11g. Testcase Let’s create a tablespace with two datafiles. It’s OMF and goes into /u01: SQL> alter system set db_create_file_dest=’/u01/app/oracle/oradata’ scope=memory; System altered. SQL> show parameter…

Read More
Oracle Team

Resize your Oracle datafiles down to the minimum without ORA-03297

By | Database management, Oracle | 36 Comments

By Franck Pachot . Your datafiles have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space, or you want to move some files without moving empty blocks, or your backup size is too large. ALTER DATABASE DATAFILE … RESIZE can reclaim the space at the end of the datafile, down to the latest allocated extent. But if you try to get lower,…

Read More
Gérard Wisson

Documentum upgrade project – sharing experience

By | Application integration & Middleware | One Comment

A few weeks ago, we finished a Documentum upgrade at a customer site. Now, after having analyzed and made a status point (we do that after each upgrade project to optimize our procedures and skills) it is time to share our experiences. In this post and in the ones that will follow we will describe which issues we were confronted with, which bugs we discovered, and how we proceed to go forward to have a…

Read More
Oracle Team

What’s the consequence of NOLOGGING loads?

By | Database management, Oracle | No Comments

By Franck Pachot . When you load data in direct-path and have the NOLOGGING attribute set, you minimize redo generation, but you take the risk, in case of media recovery, to loose the data in the blocks that you’ve loaded. So you probably run a backup as soon as the load is done. But what happens if you have a crash, with media failure, before the backup is finish? I encountered recently the situation but…

Read More
Oracle Team

How to remap tablespaces using Oracle Import/Export Tool

By | Database management | One Comment

Since Oracle 10g, Oracle provides a great tool to import and export data from databases: Data Pump. This tool offers several helpful options, particularly one that allows to import data in a different tablespace than the source database. This parameter is REMAP_TABLESPACE. However, how can you do the same when you cannot use Data Pump to perform Oracle import and export operations? I was confronted with this issue recently, and I had to deal with…

Read More
Oracle Team

Oracle 12.1.0.2.1 Set to Join Conversion

By | Database management, Oracle | No Comments

By Franck Pachot . Recently, I described the Partial Join Evaluation transformation that appeared last year in Oracle 12c. I did it as an introduction for another transformation that appeared long time ago in 10.1.0.3 but was not used by default. And even in the latest Oracle 12c patchset 1 (aka 12.1.0.2.0) it is still not enabled. But it’s there and you can use it if you set optimizer_features_enabled to 12.1.0.2.1 (that’s not a typo!)….

Read More
Stéphane Haby

How to find the SQL Server Management Pack in the SCOM database

By | Database management | No Comments

While working on a customer project, I needed to retrieve the SQL Server SCOM Management Pack version. Unfortunately, the SCOM team took a while to answer and as I am the DBA, I have access to the SCOM databases. So let’s have a look at how we can get this the “hard” way. On 30/06/2014, a new Management Pack was published for SQL Server. I have installed the last package and a lot bugs were fixed…

Read More
Nathan Courtine

Deploying a SQL Server database to Azure

By | Database management | One Comment

Deploying an SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014. It can be useful for an organization  that wants to reduce its infrastucture management, simplify the deployment, or have a fast virtual machine generation. Concept This new feature is a wizard which allows either to copy or migrate an On-Premise SQL Server database to a Windows Azure virtual machine. The following schema explains the main process…

Read More
Stephane Biehler

Documentum: some useful queries (DQL/IAPI)

By | Application integration & Middleware | 9 Comments

In this blog post I want to sharing some useful DQL and IAPI queries that I am using all the time. They are more dedicated to Documentum support/debug and grouped by components. In order to use them, I recommend Qdman: it is the best tool I know to use DQL and IAPI scripts. 1. xPlore It regroups both the search engine and the index management. DQL Dsearch select * from dm_document search document contains ‘manual.doc’…

Read More
David Barbarin

SQL Server 2014: DBCC CHECKDB and ReFS support

By | Database management | One Comment

Have you noticed an interesting behavior with SQL Server 2014 when you are running a dbcc checkdb command? If not, you should have a look at this blog post. I discovered it completely by accident during some tests. If you watch carefully, you will see “weird” files appear while the dbcc checkdb command is running. Below is a sample of the file you will find near the corresponded database file: The file immediately disappears after…

Read More