Infrastructure at your Service

Franck Pachot

Unstructured vs. structured

By | Oracle | One Comment
 

 The title of this blog post was: “Tracing DBMS_RCVMAN for reclaimable archivelogs” until I started to write the conclusion… In a previous post I mentioned that there’s a bug with archivelog deletion policy when you want to mention both the ‘BACKED UP … TIMES TO …’ and ‘APPLIED’ or ‘SHIPPED’ as conditions for archived logs to be reclaimable. I opened a SR, they didn’t even try to reproduce it (and I can guarantee you can…

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 18 – Instead of triggers on views

By | Database Administration & Monitoring | No Comments
 

 It has been quite a while since the last post in this series but today comes the next one. Being at a customer this morning this question popped up: Can we have instead of triggers on a view in PostgreSQL as well? I couln’d immediately answer (although I was quite sure you can) so here is the test. I took an example for Oracle from here and re-wrote it in PostgreSQL syntax.

Read More
Daniel Westermann

Auto pre-warming in EDB Postgres Advanced Server 10

By | Database Administration & Monitoring | No Comments
 

 Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which are currently loaded in to shared_buffers to disk and then re-read the buffers automatically when the instance is restarted. Lets see how it works.

Read More
Franck Pachot

Dynamic Sampling vs. Extended Statistics

By | Oracle | 2 Comments
 

 On datawarehouse databases, I frequently recommend increasing the level of dynamic sampling because: Queries have complex predicates with AND, OR, IN(), ranges and correlated values for which the optimizer cannot estimate the cardinality properly Queries are long anyway (compared to OLTP) and can afford more parse time to get an optimized execution plan However, there’s a drawback with this approach because sometimes the dynamic sampling estimation may give bad estimations, and supersedes the static statistics…

Read More
Stephane Biehler

Documentum xPlore: Tuning of JVM for high throughput and low CPU usage

By | Application integration & Middleware | No Comments
 

 Sometimes you have java processes or even jboss servers using a lot of CPU. In my example I had an xPlore dsearch server using like 98% of the cpu. When using jconsole and jvisualvm I figured out the garbage collector was using 50 to 60% of the cpu time. This was because the server was indexing and accessing the internal DB very often. Hence a lot of objects were created, the JVM was not correctly…

Read More
Stephane Biehler

Documentum xPlore: Several ways to start an Index Agent

By | Application integration & Middleware | No Comments
 

 In order to start index agents, you have several ways, depending on how you need to start them. 1. Use the documentum job dm_FTIndexAgentBoot. If you setup start_index_agents=T in the server.ini, the job will be called when the docbases are started. 2. Use the web interface: Login to http://server:9200/IndexAgent/ with docbase credentials and select “Start in normal mode” 3. Login to DA and go to Indexing Management -> Index Agents and Index Servers Right click…

Read More
Morgan Patou

Documentum – Unable to stop an IDS configured in SSL?

By | Application integration & Middleware, Entreprise content management | No Comments
 

 When working with the IDS, you might face some interesting behaviors as mentioned in the last blog I wrote for example. This one will focus on the SSL part of the IDS on the target side. On this blog, I will start with showing the content of our start/stop scripts and how it is working in non-SSL, then switching to SSL and try again. Therefore for this blog, I quickly installed a test IDS 7.3 using…

Read More
Morgan Patou

Documentum – Unable to configure IDS 7.3 for a docbase

By | Application integration & Middleware, Entreprise content management | No Comments
 

 In this blog, I will talk about an issue with the IDS 7.3 which is installed on a Content Server 7.3. The IDS is the Interactive Delivery Services. It is a product provided by OpenText that needs to be installed on a Content Server (for the “Source” part) and on a Target Server (for the “Target” part). The IDS can be used to publish content from a Documentum repository to a target machine for use…

Read More
Morgan Patou

Documentum – ActiveX error 12019 in D2-Config during export

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Some months ago at a customer, we started the rollout of some security baselines on a new application (not yet productive). One of the changes was to enforce the use of TLSv1.2 on all our Documentum Clients like D2/D2-Config (4.5, 4.6, 4.7), DA (7.2, 7.3), aso… TLSv1.2 was already enabled before that but there was also a fallback to TLSv1.1 or 1.0. For Security reasons, at some point you will need to ensure that TLSv1.2…

Read More