Does IBM Data Studio have IntelliSense features or Intelligent code completion something like below? I would like to write an SQL query with IntelliSense type functionality. I have IBM Data Studio 4.1.3 Note: for getting quick help, I have also asked in stackoverflow

I've followed this simple guide and I was able to install DB2 on Docker. I now would like to import a sample database to play with. So I open IBM Data Studio, I right click on the instance > New database... , I fill up with my user name and password but then an error appears: > The system cannot verify the instance that you specified. Either enter > a valid instance name or click on the button next to the Instance name > field and select one from the list. > com.ibm.datatools.adm.explorer.ui.model.InstanceException: An internal > error occurred during: "Verifying instance db2inst1 in system > 192.168.1.44.". If I expand the error for more details I see: > 'Verifying instance db2inst1 in system 192.168.1.44.' has encountered > a problem. > > An internal error occurred during: "Verifying instance db2inst1 in > system 192.168.1.44.". > > An internal error occurred during: "Verifying instance db2inst1 in > system 192.168.1.44.". > > com.ibm.db2.das.core.DasMessageIdentifier (initialization failure) A dive in the official documentation brings me to this solution but I don't think that could be the problem. What intrigues me is the 'dot' (.) after the IP address. Could this be the error? Or is there any other way to import a sample database from IBM Data Studio?

In Data Studio I can connect to a sever/database, go down to Users And Groups, right-click on Users and add a new one. But the program never asks me for a password. How can I specify it? Also, no matter how many times I tried to "Save changes" they are never saved. I even tried to "generate change" and run it, but it always fails. I am connecting as the only user that exists on the server: db2admin. If db2admin has no authority to manage users, then who has?

I'm using the latest version of IBM Data Studio 4.1.2.0 I tried to reorg a table using IBM Data Studio after some alterations on the table with this command. reorg table MYTABLE; This command shows an error >REFRESH was expected instead of reorg But even after using the REFRESH command, the table doesn't come out of the "reorg pending" state. The same command when I tried it via the DB2 Command Line Processor worked perfectly fine. Any suggestions on how to to enable the REORG command in Data Studio or is it not supported at all?

I am trying to run a query in Informix, doing a join in a table of logs where we save the record of insertion of the rows. Notice that the query below brings two results, with different insertion dates: select * from log_cipessoa where cgccpf = 1541247000188 Results: cgccpf tppessoa tp_dml dt_insercao ------------- -------- ------ --------------------- 1541247000188 1 INSERT 2018-03-06 15:05:42.0 1541247000188 2 INSERT 2018-03-27 09:54:45.0 Now, I want to bring the rows that were inserted after the 2018-03-21 day, but while doing the join, informix seems to merge the dt_insercao column with the most recent date. And according to the log above, Informix should only return the second line, where the column tppessoa with the value 2 and dt_insercao 2018-03-27 09:54:45.0 SELECT pe.cgccpf ,pe.tppessoa ,REPLACE(LTRIM(RTRIM(pe.nomepessoa)), ' ', ' ') AS nomepessoa ,lg.dt_insercao FROM CIPESSOA pe INNER JOIN LOG_CIPESSOA lg ON lg.cgccpf = pe.cgccpf WHERE lg.tp_dml = 'INSERT' AND lg.dt_insercao > '2018-03-21 20:09:32' AND lg.dt_insercao <= '2018-03-31 20:00:00' and pe.cgccpf = 1541247000188 --FILTER ONLY FOR DEMONSTRATION Results: cgccpf tppessoa nomepessoa dt_insercao ------------- -------- ----------- --------------------- 1541247000188 1 XPTO LTDA 2018-03-27 09:54:45.0 1541247000188 2 XPTO LTDA 2018-03-27 09:54:45.0

I'm currently trying to log into a remote AS/400 server. I was given credentials to obtain some data and do a couple tests. After 2 failed attempts, the iAccess Client showed me an alert saying my user would be blocked if the third attempt failed, so I stopped trying. I'm reporting the event, but I need to know if the "attempt counter" resets after some time.

I have to use IBM Data studio 4 and for the life of me I cannot figure how to open another SQL script editor window. Luckily it opens with one, but then I am constrained to that single window. I don't want to go thru the trouble of having a project etc, just open another script and write a few statements. PS: I know of a workaround of right-clicking an object in the connection tree and using Data/New Select Script, but that is a PITA as I have to open Table/View trees and point at one of the objects, and of course I am not always there (on the SP/Functions tree for instance) and it takes a while for the tree to open all objects.

I have a DB2 storage group with storage paths set like C:\ D:\ E:\ Size of my C: drive is 100 GB and the other programs keep crashing because it fill data drive by one, even I can allocate more storage and extend this it first fill free space In my c:\ drive and move to new storage, I like to know is it possible to give a max size for 1 particular drive(storage path) and how? NOTE : If I can change the PathState to 'NotInUse' will it fix this , will it effect the editing of the existing data in that path ? INFO: DB2 10.1 C:\IBM\SQLLIB\BIN>db2pd -storagepaths -tablespaces -db DEMO Database Member 0 -- Database DEMO -- Active -- Up 0 days 17:16:44 -- Date 02/09 /2016 11:06:24 Storage Group Configuration: Address SGID Default DataTag Name 0x000007FFCCFCAE40 0 Yes 0 DEMOFORTEST Storage Group Statistics: Address SGID State Numpaths NumDropPen 0x000007FFCCFCAE40 0 0x00000000 2 0 Storage Group Paths: Address SGID PathID PathState PathName 0x000007FFCCFF7560 0 0 InUse C: 0x000007FFCCFCAF60 0 1 InUse E: Database Member 0 -- Database DEMO -- Active -- Up 0 days 17:16:44 -- Date 02/09 /2016 11:06:24 Tablespace Configuration: Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDD isk FSC NumCntrs MaxStripe LastConsecPg Name 0x000007FFC0018BC0 0 DMS Regular 32768 4 Yes 4 1 1 Off 1 0 3 SYSCATSPACE 0x000007FFC0021460 1 SMS SysTmp 32768 32 Yes 32 1 1 On 1 0 31 TEMPSPACE1 0x000007FFC002C360 2 DMS Large 32768 32 Yes 32 1 1 Off 1 0 31 USERSPACE1 0x000007FFC0035360 3 DMS Large 32768 4 Yes 4 1 1 Off 1 0 3 SYSTOOLSPACE 0x000007FFC003E300 4 DMS Regular 32768 16 No 16 1 1 Off 2 1 15 STORE_TS 0x000007FFC0047480 5 DMS Regular 32768 16 No 16 1 1 Off 2 1 15 INDEX_TS 0x000007FFC0055B00 6 DMS Large 32768 16 No 16 1 1 Off 2 1 15 LOB_TS Tablespace Statistics: Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped TrackmodStat e 0x000007FFC0018BC0 0 7168 7164 6944 0 220 6944 6944 0x00000000 0 0 No n/a 0x000007FFC0021460 1 1 1 1 0 0 0 0 0x00000000 0 0 No n/a 0x000007FFC002C360 2 1024 992 96 0 896 96 96 0x00000000 0 0 No n/a 0x000007FFC0035360 3 1024 1020 80 0 940 80 80 0x00000000 0 0 No n/a 0x000007FFC003E300 4 1477648 1477616 1476624 0 992 1476624 1476624 0x00000000 0 0 No n/a 0x000007FFC0047480 5 248832 248800 247792 0 1008 247792 247792 0x00000000 0 0 No n/a 0x000007FFC0055B00 6 9134368 9134336 9134112 0 224 9134112 9134112 0x00000000 0 0 No n/a Tablespace Autoresize Statistics: Address Id AS AR InitSize IncSize IIP M axSize LastResize LRF 0x000007FFC0018BC0 0 Yes Yes 33554432 -1 No N one None No 0x000007FFC0021460 1 Yes No 0 0 No 0 None No 0x000007FFC002C360 2 Yes Yes 33554432 -1 No N one None No 0x000007FFC0035360 3 Yes Yes 33554432 -1 No N one None No 0x000007FFC003E300 4 Yes Yes 33554432 -1 No N one 02/09/2016 10:12:09.687557 No 0x000007FFC0047480 5 Yes Yes 33554432 -1 No N one 02/09/2016 10:52:17.557144 No 0x000007FFC0055B00 6 Yes Yes 33554432 -1 No N one None No Tablespace Storage Statistics: Address Id DataTag Rebalance SGID SourceSGID 0x000007FFC0018BC0 0 0 No 0 - 0x000007FFC0021460 1 0 No 0 - 0x000007FFC002C360 2 -1 No 0 - 0x000007FFC0035360 3 -1 No 0 - 0x000007FFC003E300 4 -1 No 0 - 0x000007FFC0047480 5 -1 No 0 - 0x000007FFC0055B00 6 -1 No 0 - Containers: Address TspId ContainNum Type TotalPgs UseablePgs PathID Str ipeSet Container 0x000007FFC00558C0 0 0 File 7168 7164 0 0 C:\DB2\NODE0000\DEMO\T0000000\C0000000.CAT 0x000007FFC002A080 1 0 Path 1 1 1 0 E:\DB2\NODE0000\DEMO\T0000001\C0000000.TMP 0x000007FFC00350A0 2 0 File 1024 992 0 0 C:\DB2\NODE0000\DEMO\T0000002\C0000000.LRG 0x000007FFC003E040 3 0 File 1024 1020 0 0 C:\DB2\NODE0000\DEMO\T0000003\C0000000.LRG 0x000007FFC0047040 4 0 File 1303568 1303552 0 0 C:\DB2\NODE0000\DEMO\T0000004\C0000000.USR 0x000007FFC0047250 4 1 File 174080 174064 1 1 E:\DB2\NODE0000\DEMO\T0000004\C0000001.USR 0x000007FFC0050220 5 0 File 164864 164848 0 0 C:\DB2\NODE0000\DEMO\T0000005\C0000000.USR 0x000007FFC0050430 5 1 File 83968 83952 1 1 E:\DB2\NODE0000\DEMO\T0000005\C0000001.USR 0x000007FFC0050BE0 6 0 File 6504736 6504720 0 0 C:\DB2\NODE0000\DEMO\T0000006\C0000000.LRG 0x000007FFC0050DF0 6 1 File 2629632 2629616 1 1 E:\DB2\NODE0000\DEMO\T0000006\C0000001.LRG