Post reply

lawson on sql server?

  • November 25, 2002 at 7:04 pm

    #159296

    Helo:

    I am an Oracle DBA who serves as a backup DBA for a SQL Server 2000 database.

    A new application is coming on board and it will be Lawson financials running SQL Server 2000.

    I was wondering if there are any issues, obstacles or pecularities with

    Lawson Financials running on SQL server 200 that I should be aware of?

    Any information relevant to Lawson and SQL Server 2000 will surely be welcome.

    Thank you.

    David Spaisman

  • November 25, 2002 at 7:48 pm

    #442389

    Best thing is to get them to answer your question and try to get them to demo it to you on 2000. Most companies will do this as they want to build a long term relationship.

  • November 25, 2002 at 8:17 pm

    #442390

    What version of the environment and what version of the application?

    Peculiarities:

    • Like with PeopleSoft, binary sort order, case sensitive (this isn't a SQL Server default)
    • there are a set of utilities on the Lawson side to verify and rebuild the schema. You may need to learn them. Case in point: when we applied an environmental service pack, Lawson Insight started throwing errors. A verify showed they had changed the schema in the Lawson ladb (not actually what it's called, but what we call it) but the schema wasn't modified in SQL Server). Had to run a rebuild to get it back in sync.
    • If you use filegroups for performance, your Lawson administrator is going to need to know about it, because his/her piece on the Lawson side can specify down to that level.
    • Make sure there are no extra spaces or extra lines in the MICROSOFT file. This will cause a failure to connect.
    • Ensure you configure the server running Lawson Insight (if a different box from the SQL Server) to use TCP/IP. There are known performance issues with Named Pipes above and beyond the normal ones (it's slower and sometimes leads to timeouts). You can force the config using the command cliconfg from Start | Run

    There's a whole host of other things. Feel free to contact me if you want.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • November 25, 2002 at 8:20 pm

    #442391

    Oh yeah... tech support on SQL Server isn't very good from Lawson. Apparently, the same is true of Oracle. There are serveral newsgroups on Topica (http://www.topica.com), the most prominent being the Lawson SysAdmin forum where you'll likely get better support than going through the GSC. The support contract with GSC is a necessary evil... but most open a ticket with GSC and post to Topica at the same time. You'll find me there along with several others who support Lawson on SQL Server.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply