I would like a better understanding on where the GEN database resides. Our RDBMS is SQL Server 2000 and I know it isn't located with the other Lawson database here.

I couldn't find a clear answer on the knowledge base and was hoping somebody out here could help. Our App and Web server is on the same box, we are at Env. 8.0.3 esp 7 and App 8.0.3

Thanks

Hi Shawn - Welcome to the wonderful world of Lawson..

In the 8.0.3 environment The GEN database is actually contained in a bunch of ISAM files in $LADBDIR/GEN. They are stored that way as they can be read MUCH faster by the Lawson enviroment programs than if they are in an RDBMS, so response time is MUCH better. And no, you can't move it to SQL.. The utilities are designed to read directly from the files rather than using the database drivers.

If you are interested in looking at the contents of the files you can use the 'dbdump' or 'rngdbdump' utilities

Note that the data and indexes are separate.
Example:
QUEUEDJOB contains the data about jobs that are currently or have previously run - and QUEUEDJOB.i contains all it's indexes.

You'll find some valuable information in the Lawson Systems Administrator manuals. You can download the PDFs from support.lawson.com -> Products -> Product Downloads -> Server Environments -> ESP -> the Documentation button on that page will take you to all the admin docs you'll ever want to read. I recommend them highly! Note: LSF9 docs are in a similar link: support.lawson.com -> Products -> Product Downloads -> Lawson LSF 9 -> ESP -> the Documentation button

FYI: In LSF 9 GEN *IS* located in your RDBMS, so hurry up and upgrade so you can take advantage of that. :-)

g'luck!!

Dave;
Thanks for the info. That helps a lot...
Looked at your web site and loved it...

Thanks again.
Shawn