I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

Hi, 

maybe there is and issue with instance and/or database configuration

please post the output of 
db2 get dbm cfg
and
db2 get db cfg for  <database name>

Cheers,

Malek,

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

Did you set environment variables for user or for all users (system)?

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

Jan,

Thank you for responding. I had originally set these as User Environment Variables, but changed them to System EVs and rebooted. No change.

Regards,

Frank

Did you set environment variables for user or for all users (system)?

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

db2trc on -f db2trc.dmp <reproduce the error> db2trc off db2trc flw db2trc.dmp db2trc.flw db2trc fmt db2trc.dmp db2trc.fmt

Zip the .fmt and .flw files and make them available to me :-)

Jan,

Thank you for responding. I had originally set these as User Environment Variables, but changed them to System EVs and rebooted. No change.

Regards,

Frank

Did you set environment variables for user or for all users (system)?

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

PS>

Sorry for bad formatting - it should read:

db2trc on -f db2trc.dmp
<reproduce the error>
db2trc off
db2trc flw db2trc.dmp db2trc.flw
db2trc fmt db2trc.dmp db2trc.fmt

db2trc on -f db2trc.dmp <reproduce the error> db2trc off db2trc flw db2trc.dmp db2trc.flw db2trc fmt db2trc.dmp db2trc.fmt

Zip the .fmt and .flw files and make them available to me :-)

Jan,

Thank you for responding. I had originally set these as User Environment Variables, but changed them to System EVs and rebooted. No change.

Regards,

Frank

Did you set environment variables for user or for all users (system)?

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

Hi Frank,

a CSB for 12.1 GA SB 52131 was published 2024-12-28 - maybe this CSB could help.

Db2 v12.1.0 Published Cumulative Special Build Downloads

Regards,
Gerhard

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

------------------------------
Frank Fillmore
Founder and Principal
The Fillmore Group
Baltimore MD
410-465-6335
------------------------------

I have several challenges with DB2, on recent windows,  that runs with MS-Azure IDs (Microsoft ID Online Accounts),  instead of local users. 

Db2 refuses to recognize those IDS, from the operating system,  and hence , they have no privileges..  

So , My personal ID, which is a windows Admin, is USELESS to run any db2 command.   This needs to be reviewed by IBM urgently..     

What I have to do, is during install, always create an local user during the installation,  like db2admin ..     which will be the equivalent of "instance owner".  

And let wizard to configure the instance to run as this local ID.  

After install,  create a shortcut   in your desktop to open db2 command windows,  but using that local id instead.  using runAS.  

C:\Windows\System32\runas.exe /profile /user:db2admin "C:\Program Files\IBM\SQLLIB\BIN\db2cwadmin.bat"

When you click on it,  you will be prompted to provide the runas user password..  

Stuff should work there. 

------------------------------
Samuel Pizarro

Original Message:
Sent: Fri January 31, 2025 02:14 PM
From: Frank Fillmore
Subject: Can't issue db2start on Db2 for Windows v12.1 new install

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

------------------------------
Frank Fillmore
Founder and Principal
The Fillmore Group
Baltimore MD
410-465-6335
------------------------------

Samuel,

I created a local account as well. Since this Db2 implementation is on-prem and non-prod, it is not an issue. But I can imagine on MS Azure and Google Cloud Platform this could present administrative and security risks.

I'm not sure whether you should submit an Idea or an IBM Support ticket to address this.

Obrigado,

Frank

I have several challenges with DB2, on recent windows,  that runs with MS-Azure IDs (Microsoft ID Online Accounts),  instead of local users. 

Db2 refuses to recognize those IDS, from the operating system,  and hence , they have no privileges..  

So , My personal ID, which is a windows Admin, is USELESS to run any db2 command.   This needs to be reviewed by IBM urgently..     

What I have to do, is during install, always create an local user during the installation,  like db2admin ..     which will be the equivalent of "instance owner".  

And let wizard to configure the instance to run as this local ID.  

After install,  create a shortcut   in your desktop to open db2 command windows,  but using that local id instead.  using runAS.  

C:\Windows\System32\runas.exe /profile /user:db2admin "C:\Program Files\IBM\SQLLIB\BIN\db2cwadmin.bat"

When you click on it,  you will be prompted to provide the runas user password..  

Stuff should work there. 

------------------------------
Samuel Pizarro

Original Message:
Sent: Fri January 31, 2025 02:14 PM
From: Frank Fillmore
Subject: Can't issue db2start on Db2 for Windows v12.1 new install

I'm baffled.

I've just deployed a new Windows 11 workstation to serve as an internal sandbox for Db2 and related software. Db2 Advanced Edition v12 installed without a hitch. I successfully applied the license key. When I issue the db2start command in the Db2 CLP run as Administrator I receive:

SQL1390C "The environment variable DB2INSTANCE is not defined or is invalid."

Windows User Environment Variables have been set: DB2INSTDEF=DB2 and DB2INSTANCE=DB2.

The user that performed the install has been added to Windows Groups DB2ADMNS and DB2USERS as well as Administrator.

When I issue db2level command I receive:

SQL1022C  "There is not enough memory available to process the command."

I monitored memory and less than 5% is in use.

This is v12.1 GA code. I checked, but there are no Fixpacks yet for AE.

I haven't installed a net-new Db2 version on Windows since Db2 Universal Database (UDB) v8, so I guess I'm missing something simple and obvious. TIA for pointing out what that is to me.

Cheers,

Frank

------------------------------
Frank Fillmore
Founder and Principal
The Fillmore Group
Baltimore MD
410-465-6335
------------------------------