Posted by
test
|
Posted on
6:12 PM
Category:
Documentum
,
DQL
,
DUMP
,
iap
Following are the commands (DQL/IAPI) to run the jobs manually.
1.iAPI Editor
# apply,c,NULL,DO_METHOD,METHOD,S,[job name], ARGUMENTS,S,[list of arguments]
2. DQL Editor()
#EXECUTE do_method WITH method = [method name], arguments = [list of arguments]
To change the trace level of a job, use DQL:
update dm_job object set method_trace_level = [trace level] where
object_name = [job name]
To determine which jobs are currently running, use this DQL:
select object_name, r_object_id from dm_job where a_special_app = 'agentexec'
Once you get the object id, you can dump the object and see other attributes and query them as per your needs/analysis.
Happy Running jobs
Posted by
test
|
Posted on
9:32 AM
Category:
DQL
Commonly used DQLs for Documentum Admins. I update this blog whenever i get some good DQL to write , its for my personal reference as well as for other user if it helps anybody. Please use it at your own risk.
1- To see the audit trail for the particular user's login attempt to troubleshoot login related issues.
SELECT * FROM dm_audittrail
WHERE event_name='dm_connect'
AND user_name='user_name'
2- Group by clause by date to calcuate the number of documents create each day in the repository. Modify it accordingly as per your need.
select (DATEFLOOR(DAY, r_creation_date)) as r_MONTH , count(*)as cnt from amtrak_invoice where r_creation_date >= date('06/06/2011') GROUP BY (DATEFLOOR(DAY, r_creation_date))order by 1
Posted by
test
|
Posted on
6:20 AM
Category:
DCTM
,
Delete
,
Documentum
,
DQL
,
IAPI
,
Objects
Deleting bulk number of objects is a daily task in administrating the Documentum Server and its not possible to delete more than couple of thousands objects using DA or even iDQL because it takes lot of time or sometimes it hangs the server. So best way to do it is through create a text file of API commands for those objects which need to be deleted and i have compiled some steps to do that in easy way . It can be automated by using writting some job but if you need to delete instantenously by running script . Here is the solution.
1:- Create a dql file to extract object_ids of the objects which you want to delete
example
Name this file something like "extract_objectIds.dql"
---------------------------------------
select 'destroy,c,'as destroy,r_object_id from dm_document
go
quit
---------------------------------------
2:- Create a batch file to run this dql command created in above file named like
extract_objectId.bat
----------------------------------------
@echo off
setlocal & pushd
rem -=-=-=-=-=-=-=-=-=--
rem - Set these values -
rem -=-=-=-=-=-=-=-=-=--
set DOCBASE_NAME=xxxx
set DCMT_SUPERUSER=yyyy
set DCMT_SUPERUSER_PW=zzzzz
echo
"%DM_HOME%\bin\idql32" %DOCBASE_NAME% -U%DCMT_SUPERUSER% -P%DCMT_SUPERUSER_PW% -Rextract_objectIds.dql >object_Ids.log
:EOF
endlocal & popd
-----------------------------------
3:- Extract all the API commands from the log you got in previous step in your objectid.log into a new file called "destroy_objects.api"
for example , your object_Ids.log must be containing data like
destroy,c, 09xxxxxxxxxxxxxx
destroy,c, 09xxxxxxxxxxxxxx
destroy,c, 09xxxxxxxxxxxxxx
destroy,c, 09xxxxxxxxxxxxxx
4: Create a new batch file or update the above batch file and run iapi command file using the batch file.
New Batch file example (destroy_objects.bat)
----------------------------------------------
@echo off
setlocal & pushd
rem // $Id$
rem -=-=-=-=-=-=-=-=-=--
rem - Set these values -
rem -=-=-=-=-=-=-=-=-=--
set DOCBASE_NAME=xxxx
set DCMT_SUPERUSER=yyyy
set DCMT_SUPERUSER_PW=zzzzz
rem Destroying Objects
echo
echo.
""%DM_HOME%\bin\iapi32" %DOCBASE_NAME% -U%DCMT_SUPERUSER% -P%DCMT_SUPERUSER_PW% -Rdestroy_objects.api -lobjectsDeleted.log
:EOF
endlocal & popd
------------------------------------------------
Run this batch file by setting your Docbase Name , UserId, Password.
Thats it.
Happy Destroying Objects.
Note:
