The DBA might like to try
execute DBMS_STATS.GATHER_DATABASE_STATS;
The DBA might like to try
execute DBMS_STATS.GATHER_DATABASE_STATS;
1. Creating of index agents the FTI expects Server Config object to be same name as docbase. Thus shutdown docbase. Edit server.ini, change the docbase config to that of docbase name. Start back up. Now you have a server config same name. Shut down, restore the original name of the serverconfig in the server.ini. Start back up.
2. Go to DA, To security and search for acl, dm_f – ensure the owner is the docbase owner (if that name changed after a migration.
$ cd $FASTSEARCH/bin && ./startup.sh && ./nctrl start j2ee && ./nctrl start httpd && ./nctrl sysstatus
Before going to web interface, execute startup.sh in
$DOCUMENTUM/dfc/IndexAgents/IndexAgent1
To get to web interface put the full url to:
http://<fdqn>:9081/IndexAgent1/login.jsp
IBM Technology levels are obtained by using
oslevel
with no params tells you the version of AIX. (For Documentum it should be at least 5.2 currently).
oslevel -q -s
Will give a lengthy list of service packs and the technology level.
Example:
$ oslevel -q -s
Known Service Packs
——————-
5300-07-04-0818
5300-07-03-0811
5300-07-02-0806
5300-07-01-0748
5300-06-07-0818
5300-06-06-0811
5300-06-05-0806
5300-06-04-0748
5300-06-03-0732
5300-06-02-0727
5300-06-01-0722
5300-06-01-0000
5300-06-00-0000
5300-05-CSP-0000
5300-05-06-0000
5300-05-05-0000
5300-05-04-0000
5300-05-03-0000
5300-05-02-0000
5300-05-01-0000
5300-04-CSP-0000
5300-04-03-0000
5300-04-02-0000
5300-04-01-0000
5300-03-CSP-0000
$ oslevel -s
5300-06-07-0818
Which is AIX 5.3 TL6 SP7
Systems running Documentum include
$ oslevel -s
5300-06-00-0000
Which is AIX 5.3 TL6 No SP
prtconf
will tell you the cpu, network and other information. Abbreviated example below:
$ prtconf
System Model: IBM,9117-570
Machine Serial Number: 65045F0
Processor Type: PowerPC_POWER5
Number Of Processors: 2
Processor Clock Speed: 1900 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 5 manch0010
Memory Size: 4096 MB
Good Memory Size: 4096 MB
Platform Firmware level: Not Available
Firmware Version: IBM,SF240_320
Console Login: enable
Auto Restart: true
Full Core: false
At time of writing it is believed (by me) TL05 is out of support from IBM.
Hi K######,
It is not often that we get a chance to stop, and give recognition to an individual who has been a great team player, an expert in the field, and an awesome individual to work with, who for the past 3-4 weeks has assisted the US ### team to successfully deliver a solution on the RFS# ######-## for the XXXXXXXX customer. This RFS was recently signed.
I am taking that opportunity to do so now with regards to Kevin Yeandel, who has been working with the team in terms of educating us on the nuances of Documentum, and how it should be architected to be backed up and recovered. Additionally, Kevin identified “risk” and also “risk mitigation” strategies.
We still a bit of closure to do with the customer, due to no fault of our own, however to date, and given the 5-6 hr time difference, I am very pleased with Kevin, in that with very brief notice, Kevin has been able to make all calls, take charge on the calls and educate the XXXXXXXX customer, and team ### as to how to do it and do it the correct way. I look forward to working with Kevin on future assignments.
I also tried to follow up with a “Thanks award”, and received this response “Either the CNUM or the e-mail address you have entered is incorrect or the person whose e-mail address you have entered is not eligible to participate in the Thanks! Award Program at this time.
Thanks,
Dxxxxxx
Requires registration of downloadable ActiveX comp from Skype web site on Windows machine.
Register with:
regsvr32 Skype4COM.dll
Make sure Skype is installed and logged in. When you run the prog the first time you are asked a
security question. You will need credit on your Skype account and it must be useable
through the network (if doing this from within a company and behind a firewall).
Copy the code from Option Explicit to bottom into a file called isalive.ebs
usage:cscript isalive.ebs <server> <phone> <interval> <mail recipient>
Returns: Writes to console. Sends a text if server goes off line. Sends an email also
with contents of a log file.
Requires a batch file containing words to the affect:
tracert -d %1 >> c:\diags.txt
echo "Further Info:
ping server1.fdqn >>c:\diags.txt
ping server2.fqdn >>c:\diags.txt
.
Batch file must be in same dir as the vbs.
Sends a text when it comes back on-line. Code below:
Option Explicit
'skype me a text or voicemail when my server disappears off the network.
'runs on a windows platform (whatever)
'useage:
'cscript isalive.vbs 192.168.1.109 004412345678 3000 xxxxxxxxxxxx@gmail.com
'where 192.168.1.109 is the server to ping
'and 004412345678 is the number to send a message to
Dim strHost
Dim strPhoneUser
Dim fault_detected
Dim strMessage
Dim strRecipient
Dim sleeptime
Dim oSkype
Set oSkype = WScript.CreateObject("Skype4COM.Skype", "Skype_")
If Not oSkype.Client.IsRunning Then oSkype.Client.Start() End If
' Check that all arguments required have been passed.
If Wscript.Arguments.Count < 2 Then
Wscript.Echo "Arguments required" & vbCrLf
Wscript.Quit(0)
End If
strHost = Wscript.Arguments(0)
strPhoneUser=Wscript.Arguments(1)
sleeptime=3000
If (Wscript.Arguments.Count > 2) Then
sleeptime = Wscript.Arguments(2)
End If
strRecipient = ""
If (Wscript.Arguments.Count >3 ) Then
strRecipient = Wscript.Arguments(3)
End If
Wscript.Echo "Host " & strHost
Wscript.Echo "Phone " & strPhoneUser
Wscript.Echo "Recipient " & strRecipient
Wscript.Echo "sleep " & sleeptime
fault_detected = 0
do
if Ping(strHost) = True then
Wscript.Echo "Host " & strHost & " contacted"
if (fault_detected > 0) Then
strMessage= "Server " & strHost & " back on network after " & ((fault_detected * sleeptime)/1000) & " seconds"
call_contact
fault_detected = 0
End If
Else
Wscript.Echo "Host " & strHost & " could not be contacted"
fault_detected = fault_detected + 1
If (fault_detected = 1) Then
strMessage= "Server " & strHost & " missing from network"
Wscript.Echo "Contacting user on tel. no." & strPhoneUser
call_contact
do_diagnostics ' do further research then mail someone with the information
mailuser
End If
end if
WScript.sleep (3000)
loop until (1=0)
Function call_contact
Dim oSMS
Wscript.Echo "SMS : " & strMessage
Set oSkype = WScript.CreateObject("Skype4COM.Skype", "Skype_")
Set oSMS = oSkype.SendSms(strPhoneUser, strMessage)
WScript.Sleep(20000)
End Function
'Message event handler:
Public Sub Skype_SmsMessageStatusChanged(ByRef aSms, ByVal aStatus)
WScript.Echo ">Sms " & aSms.Id & " status " & aStatus & " " & oSkype.Convert.SmsMessageStatusToText(aStatus)
End Sub
'Target event handler:
Public Sub Skype_SmsTargetStatusChanged(ByRef aTarget, ByVal aStatus)
WScript.Echo ">Sms " & aTarget.Message.Id & " target " & aTarget.Number & " status " & aStatus & " " & oSkype.Convert.SmsTargetStatusToText(aStatus)
End Sub
Function Ping(strHost)
dim objPing, objRetStatus
set objPing = GetObject("winmgmts:{impersonationLevel=impersonate}").ExecQuery _
("select * from Win32_PingStatus where address = '" & strHost & "'")
for each objRetStatus in objPing
if IsNull(objRetStatus.StatusCode) or objRetStatus.StatusCode<>0 then
Ping = False
else
Ping = True
end if
next
End Function
Function mailuser
Wscript.Echo "Mailing user"
Dim cdoConfig
Dim sch
Dim objMessage
Set cdoConfig = CreateObject("CDO.Configuration")
sch = "http://schemas.microsoft.com/cdo/configuration/"
With cdoConfig.Fields
.Item(sch & "sendusing") = 2 ' cdoSendUsingPort
.Item(sch & "smtpserver") = "aserver.net"
.update
End With
Set objMessage = CreateObject("CDO.Message")
Set objMessage.Configuration = cdoConfig
objMessage.Subject = "Server Status for: " + StrHost
objMessage.From = "xxxx@xxxx.com"
objMessage.To = strRecipient
objMessage.TextBody = "The Server vanished from the network. Please see the attached file."
objMessage.AddAttachment "c:\diags.txt"
objMessage.Send
set cdoConfig = nothing
set objMessage = nothing
set sch = nothing
End Function
Function do_diagnostics ' creates an attachment that will be emailed. diags.bat runs a tracert on the server and pings a few
Wscript.Echo "Running further diags"
Dim WshShell
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run "diags.bat " + strHost '
'WshShell.Run "command.com /k " & CommandLine 'run DOS commands
WScript.Sleep(20000)
Set WshShell= nothing
End Function
I have availability in July for a new Documentum Assignment.
Last Role: “Documentum Lead for Qualification” aka building HA regulatory systems for Big Blue on AIX and developing the compliance related documentation templates. Was on site at the customer here in the UK and working with the PM’s for IBM and their customer.
Have also been coding a complex application using Java 2, Swing and XML.
Do all my documentation in LaTeX (where possible).
Previous assignments include work for EMC and SST Partners, CYA (big fan of) installations and support.
Quite an extensive CV as I have 11 years of Documentum experience since the days of EDMS98. Worked across Europe including Finland and Sweden for lots of big players. If you would like a copy then please mail me.
For a CV or a chat then please drop me a mail or “kevinyeandel” on skype.
Reminder to self how to use automatic ftp scripts.
Useful when you have lots of logs to fetch down from lots of fti or content server.
Replace dmadmin and <password> and servername accordingly.
batch file (content server):
mkdir -p c:\logs_all_systems\server0006\install
mkdir -p c:\logs_all_systems\server0006\product\5.3\install
ftp -i -s:server0006.scr
(fti):
mkdir -p c:\logs_all_systems\server0021\install
ftp -i -s:server0021.scr
where -i is to ignore manual requests for responses from server
script file (servernnnn.scr) for content server:
open server0006.domain.net
dmadmin
<password>
bin
cd /app/documentum/dmadmin/
lcd c:\logs_all_systems\server0006
get install.log
lcd c:\logs_all_systems\server0006\install
cd /app/documentum/dmadmin/install
mget dmadmin*
cd /app/documentum/dmadmin/product/5.3/install
lcd c:\logs_all_systems\server0006\product\5.3\install
mget dmadmin*
quit
fti:
open server0021.domain.net
dmadmin
<password>
bin
lcd c:\logs_all_systems\server0021\install
cd /app/documentum/dmadmin/install
mget dmadmin*
quit
After running the uninstaller clean up the schema. Useful in cases of migration when sysadmin’s password can’t be legally extracted from the Oracle dba and you need to crack on.
set heading off
set feedback off
spool dropobj_x.sql
select ‘drop ‘||object_type||’ ‘||object_name||’ ;’
from user_objects
where object_type <> ‘INDEX’
and object_type <> ‘DATABASE LINK’
and object_type <> ‘PACKAGE BODY’
and object_type <> ‘TRIGGER’
and object_type <> ‘LOB’
order by created;
spool off
set heading on
set feedback on
If you have to have your schema created for you by the hosting company then this is what is required.
Make sure to ask the developers if any triggers will be required as you may wish to add this at the same time.
Schema Parameters (Tried, tested and in use)
GRANT ALTER SESSION TO xy_resource;
GRANT CREATE DATABASE LINK TO xy_resource;
GRANT CREATE INDEXTYPE TO xy_resource;
GRANT CREATE OPERATOR TO xy_resource;
GRANT CREATE PROCEDURE TO xy_resource;
GRANT CREATE PUBLIC SYNONYM TO xy_resource;
GRANT CREATE ROLE TO xy_resource;
GRANT CREATE SEQUENCE TO xy_resource;
GRANT CREATE SESSION TO xy_resource;
GRANT CREATE SYNONYM TO xy_resource;
GRANT CREATE TABLE TO xy_resource;
GRANT CREATE TYPE TO xy_resource;
GRANT CREATE VIEW TO xy_resource;
GRANT SELECT_CATALOG_ROLE TO xy_resource;