Archives by date

You are browsing the site archives for 2016.

Pause/Resume E1 Scheduler with SQL

Below are SQL statements that can be used to Pause and Resume the E1 Job Scheduler:

update sy900.f91300 set SJSCHCTCD01='011' where sjschjbnm='*SCHEDULER'

update sy900.f91300 set SJSCHCTCD01='111' where sjschjbnm='*SCHEDULER';


How To Find Basic Linux Hardware Info

You can use the below to find some basic information about the hardware your Linux system is installed on:

How much RAM is installed and how much of it is in use (megabytes)?

$ free -m
 total used free shared buffers cached
Mem: 3949 3189 760 0 599 1594
-/+ buffers/cache: 995 2954
Swap: 16386 109 16277

Processor type:

$ cat /proc/cpuinfo

Check the size of the hard drive and what hard drives are available in the system.
This command will also list USB drives and sticks. You need root permissions to execute the fdisk command:

$ sudo fdisk -l | grep GB
Disk /dev/sda: 42.9 GB, 42949672960 bytes
Disk /dev/sdb: 107.3 GB, 107374182400 bytes

UPDATE 01-04-2018: Another handy command for finding disk space is “df”:

$ df
Filesystem                  1K-blocks    Used Available Use% Mounted on
/dev/mapper/rootvg-usrlv      5232640 1856376   3376264  36% /usr
/dev/mapper/rootvg-homelv     8378368  189912   8188456   3% /home
/dev/sda1                      520868  122896    397972  24% /boot

Got any other tips for me?

How To Find Your Linux Version

I’ve been doing a few things in Linux lately and needed a couple things like: What version of Linux am I using?

$ lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Release: 5.5
Codename: Carthage

This Linux stuff is a little new for me, so hope that helps someone else out there.

How To Add An iSeries JobQueue To Oracle JDE EnterpriseOne

This is old news to many, but I have recently needed to go through this process again and had a heck of a time finding documentation on it. So, this is now my documentation on how to add an iSeries job queue to Oracle JDE EnterpriseOne.

  1. Login to the IBM iSeries server as ONEWORLD
  2. Use DSPSBSD QBATCH and choose option 6 to get the next available sequence number. You may need to page-down see the last entry.
  3. Press F5 twice to get out of the DSPSBSD program and back to the A98OWMNU.
  4. Choose option 11 to Create Job Queue
  5. Enter the name of your new job queue and the next open sequence number that you found earlier.
  6. Use command ADDJOBQE to add a job queue entry to an active subsystem.
    1. Example:
    2. CHGJOBQE will permit you to make changes to the job queue’s description, i.e. maximum active jobs.
  7. Use the DSPSBSD command to verify that the previously added job queue is recognized by the subsystem and have been setup with a max active job of what you indicated in the MAXACT parameter.

Like I said. Most people probably know this already, but I just needed a place to put it so that I don’t have to search for it next time.

File Cleanup Using Windows BAT/CMD Files

I have used thisbatch script to purge file base on their last modified date and provide a log of the files that were deleted. It’s really easy to read and know exactly what it is doing.

I recently recieved a VBS script that did about the same thing but was pages long.

The little script below is what I use now. I love how simple this is:

forfiles /P "E:\JDEdwards\E900\DDP\temp" /S /D -2 /C "cmd /c del @path && echo @path >> E:\TempCleanup_%date:~4,2%%date:~7,2%%date:~10,4%.log"

Got any quick simple tricks? Post them in the comments.