TruckMate 2022.2 New Features: Operations

The Migrate Database Wizard uses a different procedure when dropping existing table columns during an patch update or base upgrade.

Instead of using the TM_DROP_COLUMN procedure, now it renames the column by adding a prefix of "C2B_DROPPED_". Later when the columns are removed and the migration completed, the tables undergo a REORG to speed up the process.

Here’s an example of how this will appear during and update or upgrade.

A new DB2 STMT_CONC setting has been added to the list displayed by the DB2 Settings that Affect TruckMate Performance window.

Go to Performance > DB2 Configs to change this setting from OFF to COMM_LIT.

This setting can reduce CPU consumption by at least 30% and improve the performance for standard TruckMate tasks. A DB2 restart is not required for this option to take effect. on

Major improvements were made to the Database Utilities > Data Purge Utility application:

For automatic data purging, schedule a job to run the DATA_PURGE_DELETE_AUTO_UPTO stored procedure in the IBM Db2 Data Management Console. For example:

The tables and their purge options must be selected and saved before the purge can be performed using the stored procedure.

Previously, TruckMate used a manual login method where you enter your TruckMate username and password, select a Database and Company and click OK.

Windows authentication has been added as an alternate way to log in. Click the login method button to switch to the key icon. Once you enter your Windows username, no password is required. After this first login, you only need to indicate the database and company. This is similar to using single-sign-on.

Your TruckMate Username (defined in Security Configuration) MUST always be an exact match with your Active Directory/Windows-based Username.

A DB2 configuration change on the TruckMate servers and workstations is required to use this new login method. The 'Database manager authentication' option must be set to CLIENT and the database re-catalogued on all the runtime and actual server installs of DB2.

db2 update dbm cfg using authentication CLIENT

To run this configuration command, everyone must be logged out of the environment first and restarted afterwards for the change to take effect.

You can click the pencil or key button to toggle between the two methods.

The Flyway application used by the Database Migration Wizard now supports CLIENT authentication.

When using CLIENT authentication, the Database Migration Wizard patch updates and base upgrades MUST be performed on the server in which the database resides.

When using the Windows authentication login method, the DB2 'Database manager authentication' option must be set to CLIENT on the runtime and actual server installs of DB2. In case a server was somehow missed, TruckMate will display one of three error messages.

A new line item was added to the Communications Manager log to display the MobCommSvc.exe communications manager service version. This allows you to compare it against the version of the currently updated and patched TruckMate environment for troubleshooting.

If there is a version mismatch, the MobCommSvc.exe communications manager service executable file must be updated on the server.

To prevent scenarios where the executables for the EDI Communications Manager and the MobCommSvc.exe communications manager service are running older versions compared to the current schema version of the TruckMate database.

Several new fields were added to the SENSOR table to better match the Omnitracs mobile device workflow.

Driver ID was added to the Devices grid to indicate which resource sensor data is being sent to.

Since the Omnitracs workflow uses a U.S. setting, the Odometer Units are auto-set to miles and Total Fuel Units are set to Gallons. Mobile Device Maintenance users can view the sensor data for a particular device. Fuel data sent to TruckMate will be seen inside of the Activity log.

The Speed and Heading fields were also added to the SENSOR grid. The data is populated from the fuel reports.

The TracKing mobile network can now update maintenance hours into the Hourmeter field for trailers. These values come from the Vehicle Temperature Reports from TracKing.

To use this new feature, go to the Communications Manager application and select the Process Hourmeter check box.

Once enabled, the Hourmeter information sent via a Vehicle Temperature Report is recorded against the associated trailer.

Previously, when load offers were sent to a driver planned on a trip where the current leg was not finished (i.e., still active), the wrong "Next Planned Leg Start Zone" was often sent in the Load Offer.

To resolve this, now you can send macros for future planned legs. Two new forward macro fields were added into the Communications Macro Definition Tool.

When the Load Offer is sent to a driver on a future planned leg using these fields in the macro, it will send the correct zones.

Here is an example:

A load offer is sent to a driver planned on Legs 2 and 3 of a trip. When these macros are used, it will correctly send these zones to the device (via the Load Offer), rather than incorrectly using the Leg 1 zones (where a different Driver is already assigned)

Several changes were made to the AutoDispatch workflow in Dispatch / Multi Mode Dispatch.

Previously, attempted stops could only be recorded from "Other" statuses, and had limited functionality on bills and Trips when applied to a move.

New options for Shipper and Consignee based status behaviors allows you to design your status codes as required using options such as reattempts, attempt-and-unmatch, and cancellation.

The review and auditing features were also improved. Dispatchers can see on which trips bills were attempted and when.

The Trip Operation Planning tool, first released in TruckMate 2021.1 as a beta version, has been officially released in TruckMate 2022.2. The previous Merge & Split workflow has been removed from TruckMate.

Refer to Trip Operation Planning (TOP) - Overview in the TruckMate online help for how to use this new tool.

Changes were made to several TruckMate applications since the Trip Operation Planning tool replaces older application windows. This includes the Preplan Doubles and Merge / Switch Resources tools which have been removed.

Now you can create TBU (to be unloaded) trips via splits using the Trip Operation Planning tool.

This is used for scenarios where an LCV (long combination vehicle) trip is arriving at a terminal and while one trip is continuing on, you want to set the other to unload.

Rather than waiting until the trailers arrive at the dock to auto-split this by parking the trips at a door, now you have the option to pre-plan the split/door activities and the additional outbound move.

Refer to Trip Operation Planning (TOP) - Overview in the TruckMate online help for how to use the Trip Operation Planning tool.

The "Enable Routing Validation When Matching FB" security option settings of Warning and No Warning/Error are now supported by the Trip Operation Planning tool. Previously, only the Error setting applied and it restricted the creation of any routes that would violate the Terminal Plan(s) for any freight bills on the trip.

Use these options to set the permission level for each user: