Infrastructure at your Service

Yann Neuhaus

Alfresco 5.2 our DMS of choice!

By | Entreprise content management | No Comments
 

 Introduction Nowadays companies have to deal with lots of electronic documents, some of them being mission critical. Insurances, Banks and Pharma industries are good candidates for ECM/DMS solutions since they produce and deal with lots of documentations, contracts and receipts. Usually the largest ECM/DMS infrastructures can be found at those customers which initiate large digitalization processes. However even for smaller businesses, managing e-documents like sales quotations, offers, answers to RFIs and RFPs becomes mission critical….

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 17 – Identifying a blocking session

By | Database Administration & Monitoring | No Comments
 

 One single blocking session in a database can completely halt your application so identifying which session is blocking other sessions is a task you must be able to perform quickly. In Oracle you can query v$session for getting that information (blocking_session, final_blocking_session). Can you do the same in PostgreSQL? Yes, you definitely can, lets go.

Read More
Morgan Patou

Documentum – Change password – 5 – CS/FT – JBoss Admin

By | Entreprise content management | No Comments
 

 The next password I wanted to blog about is the JBoss Admin password. As you know, there are several JBoss Application Servers in Documentum. The most used being the ones for the Java Method Server (JMS) and for the Full Text Servers (Dsearch/IndexAgent). In this blog, I will only talk about the JBoss Admin password of the JMS and IndexAgents simply because I will include the Dsearch JBoss instance in another blog which will talk…

Read More
Morgan Patou

Documentum – Change password – 4 – CS – Presets & Preferences

By | Entreprise content management | No Comments
 

 In a previous blog (see this one), I already provided the steps to change the BOF password and I mentioned that this was more or less the only important account in the Global Registry. Well in this blog, I will show you how to change the passwords for the two other important accounts: the Presets and Preferences accounts.   These two accounts can actually be created in a dedicated repository for performance reasons but by…

Read More
Morgan Patou

Documentum – Change password – 3 – CS – Installation Owner

By | Entreprise content management | No Comments
 

 In this blog, I will describe the few steps needed to change the Documentum Installation Owner’s password. As you all know, the Installation Owner is (one of) the most important password in Documentum and it is probably the first you define even before starting the installation.   As always, I will use a linux environment and in this case, I’m assuming the “dmadmin” account is a local account to each Content Server and therefore the…

Read More
William Sescu

OUD 11.1.2.3 – Patch 25840309: OUD BUNDLE PATCH 11.1.2.3.170718

By | Database Administration & Monitoring | No Comments
 

 A new OUD bundle patch was release at the 18th of July 2017, and this gives me the opportunity to show how fast an OUD can be patched, if configured correctly. In case you have an OUD multi master replication with a load balancer virtual IP on top, then zero downtime patching is possible. This is the configuration that I usually recommend. Not only for high availability, but also for maintenance. A typical OUD installation…

Read More
Clemens Bleile

Recommended DB Parameters on the Oracle Database Appliance (ODA)

By | Database Administration & Monitoring, Database management, Hardware & Storage | No Comments
 

 When creating a DB on the ODA using # oakcli create database -db <db-name> a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking=’FULL’ db_block_checksum=’FULL’ db_lost_write_protect=’TYPICAL’ filesystemio_options=’setall’ parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages=’ONLY’ In recent projects I saw a couple of DBs running on ODA, which did not have (all) those parameters set, because the DBs were migrated from a non-ODA-platform and the customer took over…

Read More
Morgan Patou

Documentum – Change password – 2 – CS – dm_bof_registry

By | Entreprise content management | No Comments
 

 When installing a Global Registry on a Content Server, you will be asked to setup the BOF username and password. The name of this user is by default “dm_bof_registry” so even if you can change it, I will use this value in this blog. This is one of the important accounts that are being created inside the Global Registry. So, what would be the needed steps to change the password of this account?   Let’s…

Read More
Morgan Patou

Documentum – Change password – 1 – CS – AEK and Lockbox

By | Entreprise content management | One Comment
 

 This blog is the first one of a series that I will publish in the next few days/weeks regarding how you can change some passwords in Documentum. In these blogs, I will talk about a lot of accounts like the Installation Owner of course, the Preset and Preferences accounts, the JKS passwords, the JBoss Admin passwords, the xPlore xDB passwords, aso…   So, let’s dig in with the first ones: AEK and Lockbox passphrases. In…

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 16 – DDL triggers

By | Database Administration & Monitoring | No Comments
 

 A question I received recently from a customer: Oracle gives you the possibility to create DDL triggers. DDL triggers fire (as the name implies) when DDL events occur. Can we do that in PostgreSQL? Yes, this feature is called event triggers. There is a nice list in the documentation which lists for which DDLs an event trigger can fire: Event Trigger Firing Matrix. Lets go …

Read More
Daniel Westermann

What are typed tables in PostgreSQL?

By | Database Administration & Monitoring | No Comments
 

 While reading the PostgreSQL documentation for “CREATE TABLE” I came across this: “OF type_name: Creates a typed table, which takes its structure from the specified composite type (name optionally schema-qualified). A typed table is tied to its type; for example the table will be dropped if the type is dropped (with DROP TYPE … CASCADE).” Sounds interesting, lets have a look.

Read More