Navision Version 3.56.A

HfteamHfteam Member Posts: 9
edited 2008-01-31 in Navision DOS
Hello everyone.
My database consists 12 parts, where 1 part = 2 Gb.
So there is not enough free space.
And I want to expand my database.
I have a problem with the database service name.
Now it is next:
servern database=d:\1+d:\2+d:\3+d:\4+d:\5+d:\6+d:\7+d:\8+d:\9+d:\10+d:\11+d:\12
Name = 62K
So if I add one more part the name will be 68K
In this case Navision error accure that the name have to be less then 64K.
That all.

Thank you!!!!

Comments

  • GrandeGrande Member Posts: 2
    Try to rename database part 10, 11 and 12 to a, b, c - in that way you reduce the size to 3 instead of 6 characters

    Your maximum database size will be 32 GB i 16 database parts due to the design for 16 bit operation system

    regards
  • HfteamHfteam Member Posts: 9
    But I still can't understand about 32 Gb database!
    If I rename 10, 11 and 12 to a, b, c - I reduce only 3 characters!
    It is just one more part - 13 parts = 26 Gb.
  • GrandeGrande Member Posts: 2
    if you reduce with 3 characters, you should be able to add 3 more partitions.

    ex: 10, 11, and 12 converts to a,b,c,d,e and g

    if you continue with the nameing 1-9 for the first nine parts, you should have used a total of 15 characters, leaving one more free
  • HfteamHfteam Member Posts: 9
    I understand about renaming
    servern database=d:\1+d:\2+d:\3+d:\4+d:\5+d:\6+d:\7+d:\8+d:\9+d:\a+d:\b+d:\c+d:\d
    So the name = 64K, this is a limit!!!!
    I can't understand how to add 2 more partition you mentioned.
  • David_SingletonDavid_Singleton Member Posts: 5,456
    Hfteam wrote:
    Hello everyone.
    My database consists 12 parts, where 1 part = 2 Gb.
    So there is not enough free space.
    And I want to expand my database.
    I have a problem with the database service name.
    Now it is next:
    servern database=d:\1+d:\2+d:\3+d:\4+d:\5+d:\6+d:\7+d:\8+d:\9+d:\10+d:\11+d:\12
    Name = 62K
    So if I add one more part the name will be 68K
    In this case Navision error accure that the name have to be less then 64K.
    That all.

    Thank you!!!!

    WOW the best and most reliable version of Navision is still around \:D/

    What you can try is this: (depending on which OS you have the server on).

    Copy the NAVI2.exe and client files onto the server, in the D: drive where you have the database.

    Then change directory to the D:\

    Run NAVI2 and use the parameter
    database=1+2+3+4+5+6+7+8+9+10+11+12

    since you are in the current directory you don't need the drive / directory spec.

    Now when you start the server, just point to D:\1 and the server will find the rest of the parts.

    by the way this technique works even if you have the DB on multiple drives, you just have to do the process 12 times.

    BY the way, what kind of a drive is D:, I am guessing some large RAID 10, but either way, isn't it slow with 26Gig? wouldn't it be better to split over a number of RAID 1 s?

    PS I think this is posted to the wrong forum.

    :wink:
    David Singleton
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,454
    [Topic moved from Navision Attain to Navision DOS]
  • HfteamHfteam Member Posts: 9
    Thanks David Singleton as well!
    I could expand my database from 12 to 16 parts.
    But it was local database.
    I think I'll expand my actual database next weekend.
    Now my database is going at 5 RAID.
    As for me it is rather enough.
    But the deal is that our company is startin Navision Attain in august 2007.
    So that technical equipment will use RAID 10 as an IBM data storage.
  • HfteamHfteam Member Posts: 9
    Today I tried to expand my database!
    So everything fine if you start database from *.bat file.

    d:
    servern database=1+2+3+4+5+6+7+8+9+10+11+12+13,cache=760000,
    commitcache=240000,sessions=58,serverno=1,tasks=20

    But only you try to make a windows service (Naviserver1), the error occured, because the service is looking the database in c:\winnt\system32\1

    d:
    servern database=1+2+3+4+5+6+7+8+9+10+11+12+13,cache=760000,
    commitcache=240000,sessions=58,serverno=1,tasks=20,installasservice

    Windows system variables did not help me!

    Could you help me?
    You wrote something about pointing D:\1 and the service has to find the rest parts himself????
  • rthswrthsw Member Posts: 73
    It's not enough to change the drive, you also need to change the subdirectoy with cd. So Navision will call the database in the choosen DIR.
Sign In or Register to comment.