AS400 recdef jobs listing

, ,

There is not a delivered report that you can run to list out your recdef jobs. The file that holds the recdef data is called recurjob in your Gen Database Collection.

 

To get a report of all recurring jobs that are set up in recdef on AS400, follow these instructions:

From the AS400 command line type; CALL LAWENV  hit enter and choose the subsystem in which you want to dump the records from.

qsh

rngdbdump -c GEN recurjob > /home/userprofile/recdef.csv (a dump of all recurring jobs that exist in recdef)

You can now use the wrklnk command to look in the directory listed in the rngdbdump command above to see the csv file that was created with these recurjob records.

wrklnk ‘/home/userprofile/recdef.csv’  place a 2 next to the file and hit enter

or

map a drive to your IBM i  root directory via Windows Explorer and open the .csv file from there.

or

use the System i  Navigator to open the file

LBI Report prompting for credentials even though Lawson access is granted

, ,

When clicking on an LBI report, LBI prompts for credentials even though the user has LBI access already granted:

 

This is not an uncommon occurrence, and can easily be fixed.

First, on the LBI server, check the ODBC connection (partially hidden)

In LBI >> Manage Datasource, select data source and verify the Server field matches the ODBC connection.

Run the Test Saved Connection link after saving to validate (partially hidden in screenshots)

Once you are validated, make sure the report itself is defaulting to this LBI Datasource. If so, then you should no longer be prompted for credentials. Hope this helps!

AS400 recdef jobs are submitted but not completing

, ,

If your Lawson System Foundation software is installed on an AS/400 and your recdef jobs are submitted, but just sit in an active status. View the examine log.

If the Examine Log/joblog for the batch job that was kicked off due to the schedule in RECDEF says this:

BEGIN: Recurring Job Submitted:  Day Month XX   TimeStamp

      Step1:   xx999 Started. . . . . . :  Day Month XX   TimeStamp

**Creating .prt and .dtl files

 

To understand the solution you need to be an IBM i admin that understands how to check and change both ownership and permission on files within the IFS directory.

Check your LAWDIR/Productline/IBM files for the application productline (ex. “lawapp10”, “logan” and for the “gen” productline.) They should be owned by LAWSON and both LAWSON and *PUBLIC should have *RW and all data and object authorities, except for “Execute” on the object authorities.

If they are not set that way, change the authority of the two IBM files to match what was just described above. Next take these steps:

  1. call lawenv
  2. qsh
  3. dbadmin idleAll (this will stop your idle cdriver jobs in the subsystem for this environment)

Update Infor OS Certificate

, ,

Updating the Infor OS certificate is an important housekeeping task and it is as simple as adding your new certificate to the binding on the InforOS websites.  There are two website where this can be performed. The two websites in question are InforPlatformBackend and InforPlatformUI. Follow these quick steps below to easily update your Infor OS Certificate.

First, you will need to navigate to these two sites in IIS. Once there, next you will need to edit the bindings and select your new certificate. After you select your new certificate simply perform an iisreset, and you are all done!

 

Hope this article was helpful!

How to find your lawappinstall version on AS400

, ,

Want to know how to check your lawappinstall system version on AS400? This quick guide explains how you can find out what version of the AS400 you are using on your operating system. There may be more than one way of doing this but this, we’ve found, to be a very simple solution.

 

To find your version of lawappinstall, you will need to run the command(s) below that correspond:

 

  • IBM® i®:
    call lawenv [envName]
    qsh
    grep LaVersion $GENDIR/bin/lawappinstall | sed “s/.*8-)@(#)@//”

If ran correctly, the screen will display your system’s version. Here is an example version output from each platform:
10.0.9.0.1807 2020-09-17 18:28:22

 

That’s it! Hope you found this article helpful.

Lawson Users – How to change the default application in Lawson Mingle

, ,

When logging into Lawson Mingle as a user, by default, you load into the Infor Mingle app but maybe you want to load into Lawson Business Intelligence or Lawson Portal by default always.

 

To change the default application, first login to Infor Mingle

Once, logged in, open the waffle icon on the top left

You should see all the Lawson apps you have access to here

Infor Lawson gives access to Lawson Portal and very common. In order to make that the default application, click and drag that icon to the left of the Infor Ming.le App and drop:

The first icon in the top left will always load by default.

Now reload the page and watch it load Lawson portal first.

Hope this little tip was helpful!

AS400 Lawson IBMDB program CDRIVER

, ,

On the iSeries/AS400, A CDRIVER is a Lawson IBMDB program written in “C Language” and runs on the System i platform.

Its primary use is to retrieve data from DB2 using Structured Query Language (SQL)/Call Level Interface (CLI) Application Program Interfaces (APIs).

Furthermore, Lawson Jobs are using CDRIVER. Each Lawson Job has its own CDRIVER per Data Area or Product Line. Its purpose is to run SQL commands to retrieve database records requested by the job connected to it. The job name will be automatically registered in the CDRIVER joblog and the job that is attached to it may change if REUSE is set to “ON” in the ladb.cfg.