The command "db2 prune history 200801" was executed without errors.
But the "list history" command until has all the entries.
Here's the output of db2ckrst:
Any tips?...
User Profile
Collapse
-
Shyckymn replied to How can I export the data with del but don't wanna put "" ouside the character data?in DB2What if you use "sed" command?
sed -e 's/"//g' bad_file.out > good_file.outLeave a comment:
-
"list history" command - How to remove entries?
How do I delete some entries that are result of the query below?
db2 list history containing schema.table for database
I want to remove some entries from the List History command.
It is possible? -
-
How to create a GROUP BY for use with ip address range?
Dudes,
How can I make a GROUP BY function into an SQL instruction, to count how much machines by ip address range (until the 3rd range)?
Ex: (Existent registers for a field called ip_addr)
172.17.17.1
172.17.17.2
172.17.17.3
172.18.196.12
172.18.196.22
172.22.3.1
Range 172.17.17: 3 machines
Range 172.18.196: 2 machines
Range 172.22.3: 1...
No activity results to display
Show More
Leave a comment: