Infrastructure at your Service

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 | One Comment
 

 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
Daniel Westermann

Displaying the contents of a PostgreSQL data file with pg_filedump

By | Database Administration & Monitoring | No Comments
 

 Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don’t care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted and you want to recover as much data as possible? Maybe you just want to do some research. There is a utility called pg_filedump which makes this pretty easy. Lets go …

Read More
Nicolas Penot

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 01)

By | Database management, Hardware & Storage, Operation systems, Oracle | No Comments
 

 After having worked with OVM on various architectures I can say that it is a good technology to easily build virtualized environments for production applications. Because it is based on XEN and has simple ways to deal with existing storage (FC, ISCSI, NFS, …) and networking solution (bond, lacp, …) it is a robust and convenient way to virtualized IT infrastructures keeping “bare-metal” performance. Besides, it is an hard partitioning technology which is compliant with…

Read More
Stéphane Haby

SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)

By | Database Administration & Monitoring, Database management, SQL Server | No Comments
 

 Before SQL Server 2016, you had the possibility to check the case “Send Windows and SQL Server Error Reports….” during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server 2016, after the installation, all of the CEIP are automatically turned on. Why? SQL Server and SQL Azure share the same code now. On Azure, this service existed since a long time. It collects a large…

Read More
Stéphane Savorgnano

Pass Summit 2017: how to bypass SQL Server security

By | Database Administration & Monitoring | No Comments
 

 Last Friday I saw a very interesting session in Pass Summit 2017 about how to Bypass, or Ensure, SQL Server security by Matt Martin. Matt explained us how to bypass SQL Server security with the complicity of your SQL Server DBA. Msdb is the most powerful database to get stuff done: mail, jobs… so let’s have a look how to take the power within a SQL Server instance. Start a job under SQLAgentOperator role SQLAgentOperator…

Read More
Franck Pachot

Multitenant internals: INT$ and INT$INT$ views

By | Oracle | No Comments
 

 This month, I’ll talk – with lot of demos – about multitenant internals at DOAG conference. The multitenant dictionary architecture starts with a simple idea: system metadata and data are in CDB$ROOT and user metadata and data are in PDB. And it could have been that simple. When a session connected to a PDB needs to read some system information, the session context is switched to the CDB$ROOT container and reads from CDB$ROOT SYS tablespace…

Read More