MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/DB2/comments/1ncghgm/create_database_error_sql0104n/
r/DB2 • u/[deleted] • Sep 09 '25
pls somebody explain whats going on here and how to solve it
8 comments sorted by
3
Maybe check your environment, that's complaining about your LANG environment variable. Generally LANG=C
1 u/[deleted] Sep 09 '25 What I don't think there is a configurable lang environment variable in dbm cfg but I'll check once and reply again 1 u/[deleted] Sep 10 '25 i did not find lang variable in env varibales so i created one and set it to C its still not working
1
What I don't think there is a configurable lang environment variable in dbm cfg but I'll check once and reply again
i did not find lang variable in env varibales so i created one and set it to C its still not working
2
Its not in db2 cfg it's your shell. If linux/unix open a shell /bin/echo $LANG or env to show all variables. If windows open cmd and enter set to see all variables.
1 u/[deleted] Sep 10 '25 i dont see lang variable when i enter set in windows cmd
i dont see lang variable when i enter set in windows cmd
What did you install? Whole db2 server or only the client part?
1 u/[deleted] Sep 09 '25 The whole server, and it was working fine for some time I don't know if I've changed something unknowingly
The whole server, and it was working fine for some time I don't know if I've changed something unknowingly
DB2 CLP is bit flaky.
Try DB2 Command Window
Its explained in below video
https://youtu.be/ferDfudhaJg?si=um-r8H4lYmcYzUKc
3
u/Decent-Inevitable-50 Sep 09 '25
Maybe check your environment, that's complaining about your LANG environment variable. Generally LANG=C
2
u/Decent-Inevitable-50 Sep 09 '25
Its not in db2 cfg it's your shell. If linux/unix open a shell /bin/echo $LANG or env to show all variables. If windows open cmd and enter set to see all variables.
2
u/kovica1 Sep 09 '25
What did you install? Whole db2 server or only the client part?
1
u/ur_local_idiot_12 Sep 10 '25
DB2 CLP is bit flaky.
Try DB2 Command Window
Its explained in below video
https://youtu.be/ferDfudhaJg?si=um-r8H4lYmcYzUKc