Import/Re-import a Modified BIRT Report | IBM Maximo

Goto > Administration > Report Administration
Filter desired report with attached Application (for example podetail.rptdesign, with PLUSGPO application)

1. Click to open that report

How to take Maximo DB2 Offline Backup - IBM Maximo

FIRST we have to stop maximo server to take offline backup, you can do it by using websphere GUI or by using ServerStop.bat, its totally up to your choice

now copy these below mentioned lines in notepad and save it with dot bat (i.e DB2BackupScript.bat) extension.

DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
DB2 CONNECT RESET
DB2 BACKUP DATABASE MAXDB76 USER Administrator USING Maximo76 TO "C:\Backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS EXCLUDE LOGS WITHOUT PROMPTING
DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 UNQUIESCE DATABASE
DB2 CONNECT RESET

 run these this file by using this command

db2cmd /c /w /i DB2BackupScript.bat

Note: you also can make a bat file for this command also.

LAST: now Start WebSphere back by using GUI or StopServer.bat script. whatever you like. 

Websphere Start Stop Scripts | IBM Maximo

Save these scripts into dot bat file to create as script

Start Script:

C:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin\startServer.bat MXServer 

Stop Script:

C:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin\stopServer.bat MXServer -username wasadmin -password ******

Or

We also can use Websphere jython scripts with wsadmin.bat

Start Script:

AdminControl.invoke('WebSphere:name=NodeAgent,process=nodeagent,platform=common,node=ctgNode01,diagnosticProvider=true,version=8.5.5.3,type=NodeAgent,mbeanIdentifier=NodeAgent,cell=ctgCell01,spec=1.0', 'launchProcess', '[MXServer]', '[java.lang.String]')

Find Your Own Records | IBM Maximo

for example in SR request, logged in user wants to filter his own records,

Create a new query and paste below mentioned line

reportedby= :&USERNAME&

or

:&PERSONID&

Import Data into Maximo using INTERFACE tables MIF – IBM Maximo

First of all, we need to have interface/intermediate tables to import something into Maximo from an external/3^rd party database. Suppose we want to import some inventory data or for instance we try to figure out with a real example. Let’s assume we need to import data from a legacy application into Maximo. That legacy application is actually an inventory issuance system already implemented somewhere, we have to integrate it with New Maximo Inventory system.

MATRECTRANS tables is actually the main table to

To import data into Maximo, few steps are required to configure step by step.

1.            Object Structure (OS)

2.            End Point (EP)

3.            Enterprise services (Inbound or to import data) (ES)

4.            Publish Channel (Outbound or export data, we will not use in this case) (PC)

5.            and Combine above all into an External System (ExS)

6.            Generate Interface tables

7.            Configure Cron task for Scheduling (CT)

8.            Done. Now insert data into Interface tables and Maximo will read as per given schedule in CT.

Object Structures (OS)

Fixes by Versions for Maximo and TAMIT - IBM Maximo

On December 11, 2015, IBM Software released the 7.6.0.3 Feature Pack for Maximo Asset Management

Click here: This list reflects latest and recommended fixes for Maximo Asset Management and Maximo Asset Management for IT 

Document Sequence in Maximo with DB Trigger - IBM Maximo

Maximo uses Autonumbering, which basically a Unique value with optionally prefix or suffix. 

Whenever a user hit the New (#) button in any application, Maximo generate a AutoNumber, user can change that number but the CurrVal of sequence has moved to NextVal. 

One of my client's audit requirement is to have an auto incremented unique sequencial document control numbering without jumping(missing numbers), without losing even a signal number.  

We handled this situation at database level to insert into a new field with an increment of number before insert.

1. create a DOCNUM field in PO Object by using Database Configuration, check filterable and Wildcard.

2. Create a trigger with below mentioned code to fire on PRE-INSERT, get max(DOCNUM) from all POs , increment with 1 and Assign value to DOCNUM. 

3. If PO type is STD then a word 'PO' will be prefixed with Number else 'SO'

4. also Concat the fiscal year between prefix and actual number (SO-16-12345)

Trigger Code is as below:

CREATE OR REPLACE TRIGGER MAXIMO.PO_TEST
  NO CASCADE BEFORE INSERT
  ON MAXIMO.PO
  REFERENCING
    NEW AS N
    OLD AS O
  FOR EACH ROW
BEGIN
DECLARE POTYPE1 VARCHAR(10);
DECLARE YY INTEGER;
  IF N.POTYPE = 'STD' THEN
    SET POTYPE1='PO';
  ELSE
    SET POTYPE1='SO';
  END IF;
  Select to_char(add_months(sysdate,7),'YY') INTO YY from sysibm.sysdummy1;
SET N.ROWSTAMP = NEXTVAL FOR MAXSEQ
   ,N.DOCNUM = POTYPE1||YY||(select LPAD(MAX(SUBSTR(DOCNUM,7,3))+1,5,'0') from PO);
END;