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:

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

--*** RESUME 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

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
    A98OWMNU
  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:
      ADDJOBQE SBSD(QBATCH) JOBQ(R4164) MAXACT(1) SEQNBR(170)
    2. CHGJOBQE will permit you to make changes to the job queues 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.
    DSPSBSD

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.